Answer Posted / amit

Select salary
from employees
order by salary desc
limit n-1,1;

How to stop a loop early with break statements in ms sql server?

1027

---

Are all views updatable ?

1161

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

993

---

What do you mean by 'normalization'?

1072

---

What is auditing in sql server?

931

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

992

---

Explain the truncate command?

990

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1759

---

What is a Join and explain its types?

1109

---

How to optimize stored procedures in sql server?

1193

---

How we can compare two database data?

958

---

Can you roll back the ddl statement in a trigger?

989

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2493

---

What is database replication?

1154

---

Explain the commands in sql server?

1045

---