Answer Posted / deepak rohilla

Timestamp is used typically as a mechanism for version-
stamping table rows.

What is difference between rownum and row_number?

695

---

How you can get a list of all the table constraints in a database? : Sql server administration

687

---

Does view occupy space?

700

---

How do you drop an index?

676

---

What are the five characteristics of good data?

679

---

---

How to enable tcp/ip protocol on a sql server?

788

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

734

---

Write an SQL query to obtain the 2nd highest salary.

795

---

What are the kinds of subquery?

710

---

How to rebuild the master database?

748

---

What types of replication are supported in sql server?

736

---

What is the return type of executeupdate ()?

690

---

When multiple after triggers are attached to sql table, how to control the order of execution?

737

---

Find first and last day of current month in sql server

764

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

743

---