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 add a new dsn with the odbc driver for sql server?
Explain the use of containers in ssis and also their types?
How to list all objects in a given schema?
How to delete multiple rows with one delete statement in ms sql server?
What is the contrast amongst drop and truncate?
What is the difference between migration and upgradation in sql server?
Explain how you can deploy an SSRS report?
Define Joins?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is a synonym for manipulation?
Explain about Joins?
How to filter records of table in SQL SERVER?
how many clustered indexes can be created on a table? : Sql server database administration
What is RMS migrations?
How can you fetch alternate records from a table?
