Answer Posted / selvaraj.v

First you Clearly Learn.It's GetDATE() function, Not DetDate
() function.

In SQL Server 2000 Query :
--------------------------

Select GetDate()

Output:
------
2008-01-22 17:37:20.280

Alternate to GetDate() function:
--------------------------------

Select GetUTCDate()

Output:
-------
2008-01-22 17:37:20.280

GetUTCDATE() means Greenwhich Mean Time of Current Date
Time.

What are views used for?

778

---

How to read data in a table with "select" statements?

735

---

What does set rowcount do?

690

---

How to populate a table in sql server?

660

---

Describe and explain about SQL native client?

788

---

---

Can a table be created inside a trigger?

724

---

can you implement data mining in SSRS?

125

---

Can you name some of the dml commands in sql?

754

---

What is the simplest way to create a new database in ms sql server?

729

---

Explain what are the database objects? : SQL Server Architecture

753

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

800

---

What are the properties and different types of sub-queries?

764

---

Can primary key be a foreign key?

760

---

How to delete duplicate records based on single column from a table?

780

---

What are commonly used odbc functions in php?

723

---