Answer Posted / jayakumar

please try this....

this is very usefull to you

select colunm_name from (select distinct(column_name) from
table_name where column_name is NOT NULL order by desc)
where rownum=n;

What are the two authentication modes in sql server?

1126

---

What is database isolation in sql server? : sql server database administration

1118

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

969

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2113

---

What is resource governor?

976

---

Explain how many types of relationship?

1033

---

What command is used to rename the database?

1018

---

What are various ways to enhance the ssrs report?

988

---

What is sql collation?

1215

---

How to manipulate data from one table to another table ?

973

---

Can a table be moved to different filegroup?

979

---

What is built-in function?

1015

---

Explain the properties of a relational table?

1026

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1142

---

How many types of schemas are there?

1044

---