How do you rebuild an identity column?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

can an order by clause be used in a creation of a view?

0 Answers  

---

---

What are pessimistic lock and optimistic lock?

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

Will count(column) include columns with null values in its count?

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---