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

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

what types of replication are supported in sql server? : Sql server database administration

0 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

What is optimization and its types?

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

State the difference between local and global temporary tables?

0 Answers  

---

How do you create a clustered index?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Define self join?

0 Answers  

---