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.

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

What are the main sources of data?

0 Answers  

---

What is repeatable read?

0 Answers  

---

Why would you use sql agent?

0 Answers  

---

How much space does sql server 2016 take?

0 Answers  

---

what is hash nonclustered index

0 Answers  

---

Differentiate between a local and a global temporary table?

0 Answers  

---

How to convert a numeric expression from one data type to another?

0 Answers  

---

How do I save a stored procedure in sql server?

0 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

how can you attach more than 20 ldf files in sql server

0 Answers   IBM,

---