Answer / kumar

Batch in Sql server is a set of one or more Transact-SQL
statements sent from a client to an instance of SQL Server
for execution and it will represents a unit of work
submitted to the Database Engine by users.

Answer / sirisha

Batch is nothing but a set of sql statments that are
executed at time (all the stmts will be exceuted or none(if
any error encountered))

eg:
use [database]
GO
select empname from employee
insert employee(empno,empname)
select empno =1
,empname ='A'
GO

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

What is a Linked Server?

1 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---

What is transaction server auto commit?

0 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

What is sql view?

0 Answers  

---

How to store and query spatial data?

0 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

How you trouble shoot when any job fails

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

Define normalisation?

0 Answers  

---