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 |
What is normalization and denormalization in sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is read committed?
Can two tables share the same primary key?
How to check if stored procedure is running in sql server?
What is change data capture (cdc) feature?
How to test values returned by a subquery with the in operator?
What is PROJECTION Operation?
What are cursors?
What is clustered index
What is checkpoint in sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
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)