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??

what is create database syntax? : Sql server database administration

1113

---

What is filtered index?

1106

---

What is catalog views?

1075

---

Which are the third-party tools used in sql server and why would you use them?

916

---

What is open database communication (odbc)?

1071

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1018

---

What are trace flags?

1037

---

Explain the properties of sub-query in sql server?

1025

---

What are sql dirty pages?

1031

---

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

---

What is tablesample?

1118

---

What is scheduled job and how to create it?

1006

---

Can group functions be mixed with non-group selection fields in ms sql server?

951

---

Define outer join?

1006

---

Difference between report and query parameter.

1106

---