Answer Posted / ravinder pawar

Hi Frnds,
Pravin's logic is correct. I am just modifying it little
bit.

Select Top 1 *
From (Select Top 5 *
from HumanResources.Employee
order by EmployeeID desc)as temp

---Note If we don't use temp we'll get error as mentioned
below:
Incorrect syntax near ')'.

What is the impact on other user sessions when creating indexes?

918

---

What are trace flags and mention a few common trace flags used with sql server?

1079

---

Describe and explain about SQL native client?

1101

---

What are dml (data manipulation language) statements in ms sql server?

978

---

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

898

---

Can we call stored procedure in view in sql server?

894

---

What is parameterized reports in ssrs ?

149

---

Can sql servers link to other servers?

1077

---

Explain differentiate between a having clause and a where clause?

906

---

How to access the deleted record of an event?

1031

---

what types of replication are supported in sql server? : Sql server database administration

1039

---

Can you name some of the dml commands in sql?

1022

---

What do you understand by replication in sql server?

1056

---

What do you mean by SQL injection attack?

1052

---

What are joins in sql and what are the different types of joins?

1006

---