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 enter unicode character string literals in ms sql server?

0 Answers  


How to add more data to the testing table in ms sql server?

0 Answers  


What is a print index?

0 Answers  


How does stuff differ from the replace function?

0 Answers  


What is a recursive stored procedure in sql server?

0 Answers  






Does partitioning ssd reduce performance?

0 Answers  


What is the maximun sixes of .mdf in sql server 2005

1 Answers  


Explain database normalization?

0 Answers  


Can we add an identity column to decimal datatype?

0 Answers  


Difference between drill down and drill through report.

0 Answers  


Define left outer join?

0 Answers  


Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  


Categories