Answer Posted / chandra sekhar

select min(salary) from emp where salary in (select top n salary from emp order by salary desc)

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

1022

---

What extended events?

1062

---

What is multi-statement table-value user-defined function?

1056

---

Explain about nested stored procedure?

1084

---

What is the function of inner join?

1127

---

How to stop log file growing too big?

1064

---

Explain following error properties?

1066

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1354

---

What is transaction server explicit transaction?

1089

---

Mention the different authentication modes in sql server.

1108

---

How can I create a report based on a query? : sql server management studio

1065

---

explain the storage models of olap? : Sql server database administration

1016

---

What are “unrepeatable reads”?

1300

---

What security features are available for stored procedure?

1080

---

what authentication modes does sql server support? : Sql server database administration

1188

---