Interested to Buy Any Domain ? << Click Here >> for more details...
what are batch in sql server?
- 2 Answers
- 10065 Views
- Satyam, I also Faced
- E-Mail Answers
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 indexed views? plz explain with example?
which backup strategy you are following at ur company
What are trace flags and mention a few common trace flags used with sql server?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is difference between temp table and cte?
Advantages and Disadvantages of Cursor?
15 Answers Polytechnic, TCS, Zenith,
What is database black box testing?
Difference between primary key and clustered index?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is difference between index and primary key?
What is log ldf?
What is difference between after and before?
-
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)
