Answer Posted / sagar dhande

select top 2(salary) from (select top 3 (salary) from
dbo.employee order by salary desc)
order by salary

What are different types of views?

894

---

Explain the benefits of user-defined functions?

989

---

How to check status of stored procedure in sql server?

914

---

Can you leave a union at any time?

1004

---

What is the difference between a function and a trigger?

1014

---

What is sql view?

956

---

Explain the difference between function and stored procedure?

900

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

902

---

Explain sql delete command?

1005

---

What is a virtual table in sql?

944

---

What is schemabinding a view?

866

---

What is sharding?

114

---

How do users use Report Builder with SQL Server data sources?

146

---

Explain about system database?

1002

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

897

---