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 is the architecture of ms sql reporting service?

0 Answers  

---

Give a example to search fr a string in all stored procedure in sql server.

0 Answers  

---

How to create user messages with print statements in ms sql server?

0 Answers  

---

Define the one-to-one relationship while designing tables.

0 Answers  

---

What is the maximum size of a row in sql server?

0 Answers  

---

Give an example of SQL injection attack ?

0 Answers   HAL,

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

Can you explain different types of joins?

0 Answers  

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

Explain boyce and codd normal form(bcnf)?

0 Answers  

---

What is a filestream?

0 Answers  

---