Answer Posted / lekhraj

select top 1 * from(select top 2 * from tbl_test order by 1
asc) as at order by 1 desc

What are the types of normalization?

972

---

Benefits of Stored Procedures?

919

---

How to create a view on an existing table in ms sql server?

1054

---

What are truncate options available in sql server? : sql server database administration

968

---

What is inner join? Explain with an example?

1120

---

What are out-of-range errors with date and time literals?

967

---

How to create a simple stored procedure in ms sql server?

979

---

Explain about sql server login?

1029

---

Explain the steps to create and execute a user-defined function in the sql server?

921

---

How to change the ownership of a schema in ms sql server?

1095

---

Explain about protocol layer present in SQL server?

1108

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

955

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

914

---

Explain what are the different index configurations a table can have?

1039

---

How to test subquery results with the exists operator?

1036

---