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

What are “lock” hints?

0 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

what is database replicaion? : Sql server database administration

0 Answers  

---

How you trouble shoot when any job fails

0 Answers  

---

What stored by the model? : sql server database administration

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

What is dimension table? : sql server analysis services, ssas

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

---

What happens to a statement batch if there is a compilation error?

0 Answers  

---

How to list all tables in the database using odbc_tables()?

0 Answers  

---

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

---