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 |
Does a full backup include transaction log?
How many types of database relationship in sql server?
What is an entity-relationship diagram (erd)?
Can we use custom code in ssrs?
List all types of constraints in sql server?
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
What is the difference between the 2 operating modes of database mirroring?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What are points to remember while using the fillfactor argument?
What do you understand by the denormalisation?
what is a correlated sub-query? : Sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
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)