what are batch in sql server?
Answers were Sorted based on User's Feedback
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 |
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 |
How to enter unicode character string literals in ms sql server?
How to add more data to the testing table in ms sql server?
What is a print index?
How does stuff differ from the replace function?
What is a recursive stored procedure in sql server?
Does partitioning ssd reduce performance?
What is the maximun sixes of .mdf in sql server 2005
Explain database normalization?
Can we add an identity column to decimal datatype?
Difference between drill down and drill through report.
Define left outer join?
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?