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

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

---

Diffrent types of function

1 Answers   Wipro,

---

What do you mean by data integrity?

0 Answers  

---

How do I connect to sql server database?

0 Answers  

---

How to round a numeric value to a specific precision?

0 Answers  

---

1 01 101 01010

0 Answers  

---

What do you mean by table and field in sql?

0 Answers  

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---