Answer Posted / siva

it returns int

How to rebuild all indexes on a single table?

769

---

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

731

---

What is @@error in sql?

799

---

What is the default sql server instance name?

751

---

What is the ‘fillfactor’?

728

---

---

What is sparse columns of sql server 2008?

790

---

What is the difference between getdate and sysdatetime?

718

---

Detail about query optimizer?

798

---

What is triggers and its types?

725

---

How to modify existing triggers using "alter trigger"?

700

---

What are different type of Collation Sensitivity?

741

---

Do you know what is rank function?

806

---

What are the encryption mechanisms in sql server?

732

---

Can two different columns be merged into single column? Show practically?

820

---

How to return the second 5 rows in ms sql server?

785

---