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.

Tell me about normalization in DBMS.

995

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1040

---

What are .mdf files?

935

---

What is sql or structured query language?

1149

---

What are the new features of sql server 2012 reporting service?

133

---

What is partition index in sql server?

1118

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1041

---

Will the writetext statement activate a trigger?

1092

---

What is blocking and how would you troubleshoot it? : sql server database administration

1041

---

Explain having clause?

963

---

Can a rule be bound to any column of any data type?

961

---

What is meant by indexing?

1019

---

What is dimension table? : sql server analysis services, ssas

1016

---

What do you know about normalization and de- normalization?

925

---

What is SQL Azure Fabric?

110

---