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 get nth highest salary from employee table.

1163

---

How can you ensure that the database and sql server based application perform well?

1079

---

What are the commands used in DCL?

1028

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

885

---

What is bulkcopy in sql?

943

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2929

---

What is the recommended total size of your memory optimized tables?

966

---

How to add additional conditions in SQL?

1022

---

What do you understand by recursive stored procedure?

930

---

What is sleeping status in sql server?

1023

---

What is the difference between createstatement and preparedstatement?

942

---

How to run queries with sql server management studio express?

1093

---

What do you understand by a view? What does the with check option clause for a view do?

1004

---

What is model database in sql server?

1052

---

What is the command used to check locks in microsoft sql server?

1044

---