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;

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

605

---

How do you check sql server is up and running?

588

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

653

---

How to check if a table is being used in sql server?

606

---

Explain the difference between functions and stored procedures in sql server?

567

---

---

Which is the main third-party tool used in sql server?

565

---

What are parameterized reports? What are cascading parameters in ssrs reports?

110

---

Do you know what is rank function?

716

---

What is primary key index?

630

---

What is difference between joins and subqueries?

627

---

Do you know what is normalization of database? What are its benefits?

646

---

How can I change procedure name in sql server?

626

---

What is a unique key constraint?

640

---

What is deploy, process and build? : sql server analysis services, ssas

656

---

Explain how many normalization forms?

658

---