how to rest identity columns in sql server

3 Answers   Matrix,

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

Explain “not null constraint” in sql server?

0 Answers  

---

What is dataset and its uses

2 Answers  

---

What is transaction server isolation?

0 Answers  

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

---

What function does a database engine serve in the sql server?

0 Answers  

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

---

What is an expensive query?

0 Answers  

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

---

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---