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 side by side migration in sql server?

0 Answers  

---

what is sql server? : Sql server database administration

0 Answers  

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

---

What is data modeling and Reterminal integrity?

0 Answers  

---

Explain transaction server distributed transaction?

0 Answers  

---

What is the purpose of data source?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

Why we use functions in sql server?

0 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---