Answer Posted / sanjeev aggarwal

If there are two salaries are same in a single table then
what we do??
example:-

id salary
s1 1200
s2 1500
s3 1200
s4 1500
s5 1800

now what query we used??

List the data types available in mssql?

1102

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1045

---

What is the full form of dql?

1024

---

how to do partition in sqlserver

2546

---

Is ssrs support other database except ms sql server?

142

---

What are the different types of locks in the database?

973

---

Tell me about the approaches which you used to counter the DI problems.

1427

---

Define msdb database?

1077

---

What different steps will a sql server developer take to secure sql server?

1039

---

what is a transaction? : Sql server database administration

1050

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

1000

---

What is difference between drop truncate and delete?

1153

---

What is the use of partition by in sql server?

968

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

1029

---

How can you stop stored procedures from recompiling?

947

---