How to drop an existing schema in ms sql server?

0 Answers  

---

What is the use of custom fields in report?

0 Answers  

---

What are commit and rollback in sql?

0 Answers  

---

Why truncate is ddl command?

0 Answers  

---

What is sql server locking?

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,

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

---

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

---

List the different types of collation sensitivities in sql server?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

what is the query and condition to delete datas in sql server.

2 Answers  

---