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 delete an existing row with delete statements in ms sql server?
What are sql server procedures?
What are logical database components? : SQL Server Architecture
Explain the microsoft sql server delete command?
What is a unique key constraint?
How do you implement session management in SQL Server mode?
What is the purpose of the tempdb database?
What is the difference between grant and with grant while giving permissions to the user?
How do you test your database? : sql server database administration
how to connect sybase to sql server 2005?.
How to get the number of affected rows?
Can you explain the types of Joins that we can have with Sql Server?