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

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

How to create a view with data from multiple tables?

0 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

What is split brain scenario in DB mirroring?

1 Answers  

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

Explain different types of collation sensitivity?

0 Answers  

---

Is foreign key unique?

0 Answers  

---

How to create a user name in a database?

0 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What is a bit datatype?

0 Answers  

---