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 |
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
0 Answers Amdocs, Apps Associates,
How to create a view with data from multiple tables?
Which virtual table does a trigger use?
What all db objects can be found in MSDB database of a SQL Server instance?
What is split brain scenario in DB mirroring?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is sql profiler. What are the default templates with it? : sql server database administration
Explain different types of collation sensitivity?
Is foreign key unique?
How to create a user name in a database?
What are the types of backup and tell me the difference between full and differential backup?
What is a bit datatype?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)