Answer Posted / 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 View All Answers
How to connect sql server management studio express to sql server 2005 express?
What is log shipping?
What are the steps to follow to configure SQL*Net?
What is the difference between grant and with grant while giving permissions to the user?
Write an sql query for deleting duplicate rows?
What is @@rowcount in sql?
Explain Normalization and DE normalization
List out the differences between the clustered index and non-clustered index in sql server?
How to get a list of columns in a view using the "sp_help" stored procedure?
What are points to remember while using the fillfactor argument?
What do you mean by an execution plan? Why is it used? How would you view it?
How to recreate an existing index in ms sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is the difference between lock, block and deadlock? : sql server database administration