what are batch in sql server?

Answers were Sorted based on User's Feedback



what are batch in sql server? ..

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.

Is This Answer Correct ?    16 Yes 0 No

what are batch in sql server? ..

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

Is This Answer Correct ?    11 Yes 6 No

Post New Answer

More SQL Server Interview Questions

How to delete an existing row with delete statements in ms sql server?

0 Answers  


What are sql server procedures?

0 Answers  


What are logical database components? : SQL Server Architecture

0 Answers  


Explain the microsoft sql server delete command?

0 Answers  


What is a unique key constraint?

0 Answers  






How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,


What is the purpose of the tempdb database?

0 Answers  


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

0 Answers  


How do you test your database? : sql server database administration

0 Answers  


how to connect sybase to sql server 2005?.

1 Answers   ABC,


How to get the number of affected rows?

0 Answers  


Can you explain the types of Joins that we can have with Sql Server?

2 Answers  


Categories