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.

How to create a view on an existing table in ms sql server?

1105

---

What are the different SQL Server Versions you have worked on?

987

---

Can a database be shrunk to 0 bytes, if not, why?

1079

---

What is lock escalation and what is its purpose?

960

---

What are the different types of indexes?

1087

---

What does select 1 mean?

914

---

Working with TLogs

1819

---

what types of replication are supported in sql server? : Sql server database administration

1017

---

Explain rdbms?

1007

---

what is the maximum size of a row? : Sql server database administration

989

---

What are different types of subquery?

1212

---

What is dbcc command in sql server?

1065

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1109

---

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

1074

---

What is difference between views and tables?

984

---