Answer Posted / suresh

Hi,

select top 1 * from (SELECT TOP 2 * from emp) A Order by
empno desc

What is meant by Active-Passive and Active-Active clustering setup?

1272

---

How can you manage sql azure security?

105

---

How do I port a number to sql server?

1096

---

How optimize sql query with multiple joins in sql server?

954

---

What is a rollup clause?

1018

---

What are the advantages of policy management?

1042

---

How to manipulate data from one table to another table ?

1019

---

What are the new features are introduced in sql server 2012 reporting services?

160

---

Sql server reporting services vs. Crystal reports.

140

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1165

---

How do you send email on SQL Server?

1116

---

How do I run a trace in sql server?

1038

---

What are binary string data types in ms sql server?

1390

---

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

123

---

How can we migrate from SQL server to SQL Azure?

113

---