What is system stored procedures?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

Explain triggers?

0 Answers  

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---

---

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,

---

Explain features and concepts of analysis services?

0 Answers  

---

How to connect sql server management studio express to sql server 2005 express?

0 Answers  

---

What is resource governor?

0 Answers  

---

Explain for xml explicit mode?

0 Answers  

---

Explain the microsoft sql server delete command?

0 Answers  

---

Explain the storage models of OLAP?

1 Answers  

---