Answer Posted / saber ali

select max(salary) from employee where salary in (select top
4 salary from employee order by salary desc)

Tell me about builtinadministrator?

1046

---

How can we delete a table in sql server?

1023

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1102

---

What is 2nf normalization?

1090

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

995

---

What are points to remember while using the fillfactor argument?

1018

---

Explain the concept of recursive stored procedure.

1028

---

If we delete pack Spec what will be the status of pack Body ?

1524

---

Difference between report and query parameter.

1146

---

application server is slow what may be the problem

2274

---

how to create “alternate row colour”?

152

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1078

---

What is the difference between coalesce() & isnull()?

1196

---

how to use DTS package in 2000,2005,2008 in sql server

1906

---

What are the types of processing and explain each? : sql server analysis services, ssas

1205

---