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 are commonly used mssql functions in php?

1081

---

How can you tell if a database object is invalid?

1074

---

What is sql server schema compare? How we can compare two database schemas?

1031

---

How connect excel to sql server?

998

---

What is a sql join?

1022

---

What is a covering index?

986

---

What is mssql?

985

---

can any body tell me how to know the password of current user in sql server

2073

---

Describe in brief authentication modes in sql server.

1030

---

Why use stored procedures in sql server?

1016

---

What are different types of data sources?

1020

---

What is server-level principal?

122

---

How to modify an existing user defined function?

1108

---

What is Dependency Injection and provide example?

1118

---

can a table be moved to different filegroup? : Sql server administration

979

---