Explain transaction server explicit transaction?

0 Answers  

---

What is Schema? and why we use schemas?

4 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

What is the log shipping?

0 Answers  

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---

How do I view views in sql server?

0 Answers  

---

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

How can you control the amount of free space in your index pages?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---