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

What is importing utility?

940

---

What is view in sql?

863

---

What is the difference between function and stored procedure in sql server?

1006

---

What is apply operator in sql?

971

---

What is model database? : SQL Server Architecture

1076

---

What are audit control procedures?

947

---

What is difference between delete & truncate commands?

1037

---

How to change the password of a login name in ms sql server?

973

---

How do you clear a log file?

997

---

Do you know the cursor optimization tips?

940

---

What is similarity and difference between truncate and delete in sql?

1051

---

Differentiate between ms sql server reporting services vs crystal reports?

859

---

How to create a new table in a given schema?

1129

---

How can we rewrite sub-queries into simple select statements or with joins?

938

---

What is the use of for clause?

1053

---