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 different types of joins and what does each do?

2 Answers  

---

What is the architecture of ms sql reporting service?

0 Answers  

---

How do I edit a procedure in sql server?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

What are the approximate numeric data types?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

How to retrieve field values using mssql_result()?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

How to create a new table in a given schema?

0 Answers  

---

Mention the uses of stored procedures.

0 Answers  

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---