Answer Posted / 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

How to connect sql server management studio express to sql server 2005 express?

1102

---

What is log shipping?

998

---

What are the steps to follow to configure SQL*Net?

1075

---

What is the difference between grant and with grant while giving permissions to the user?

1025

---

Write an sql query for deleting duplicate rows?

1037

---

What is @@rowcount in sql?

1056

---

Explain Normalization and DE normalization

1160

---

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

1050

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1088

---

What are points to remember while using the fillfactor argument?

1018

---

What do you mean by an execution plan? Why is it used? How would you view it?

983

---

How to recreate an existing index in ms sql server?

1116

---

User wants only to display only pdf as export option in report manager. How to achieve this?

269

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1045

---

What is the difference between lock, block and deadlock? : sql server database administration

1091

---