Answer Posted / pandian

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

How to find the source of a table in sql server?

1035

---

Explain different types of locks in sql server.

1127

---

Can we call stored procedure in trigger?

996

---

What is a livelock?

1014

---

How to get the number of affected rows?

1053

---

 Explain what is sql override for a source taLle in a mapping?

1053

---

what is database replicaion? : Sql server database administration

1268

---

Explain in brief how sql server enhances scalability of the database system?

1024

---

What is use of dbcc commands?

1121

---

What is the optimization being performed in oracle and SQL Server?

1095

---

What is bit data type?

1081

---

How to optimize stored procedures in sql server?

1240

---

Why are you getting errors when creating a new odbc dsn?

1286

---

What is user-defined function?

1033

---

What are the types of lock supported by ?

1091

---