Answer Posted / desh deepak

sp_rename 'tablename.oldcolumnname',tablenamename.newcolumnn
ame

How to get nth highest salary from employee table.

1105

---

What is intellisense?

994

---

What is spid in sql server profiler?

1028

---

What does select 1 mean?

886

---

Explain log shipping and mention its advantages.

990

---

Does sql server use java?

997

---

What is acid properties?

1023

---

What is merge statement?

1021

---

Why use view instead of a table?

883

---

How to resolve the orphan use problem? : sql server security

956

---

What is the correct order of the logical query processing phases?

876

---

What are different types of roles provided by ssrs?

144

---

How to configure odbc dsn with different port numbers?

1027

---

What is collation sensitivity? Explain different types.

964

---

What is raid, and how it can influence database performance?

1010

---