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 the disadvantages of indexes?

1151

---

What is RAID? What are the different types of RAID configurations?

1178

---

System requirements for sql server 2005 express edition?

1061

---

Define cross join in sql server joins?

1073

---

What command would you use to add a column to a table in sql server?

1354

---

Explain view in sql server?

1084

---

What does dml stand for?

991

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1055

---

When cursors are useful?

1166

---

List some major differences between triggers and stored procedures?

977

---

Define candidate key, alternate key, and composite key.

965

---

Explain important index characteristics?

1073

---

How can I add Reporting Services reports to my application?

132

---

In how many ways you can invoke ssrs reports?

145

---

What is data mart? : sql server analysis services, ssas

1099

---