Answer Posted / suraj

Selvaraj, You are wrong. I tested it.
Please, look at the output of these below queries.
'GetUTCDate' results in time difference which means it will
not give you the exact result as 'GETDATE()'.

SELECT GETUTCDATE()

-----------------------
2009-11-30 22:15:15.243


SELECT GETDATE()

-----------------------
2009-11-30 16:15:15.243


SELECT CURRENT_TIMESTAMP

-----------------------
2009-11-30 16:15:15.243

What are the joins in sql server? : sql server database administration

990

---

Explain a differential backup?

994

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

960

---

Mention a few common trace flags used with sql server?

915

---

What are acid properties of transaction?

932

---

In which format does an image save in SQL Server database ?

980

---

Differentiate sql server reporting services vs. Crystal reports?

200

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

997

---

How to see existing views in ms sql server?

1020

---

Define tempdb database?

974

---

Do you know what is sql service broker?

1052

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6861

---

What are the built in functions in sql server?

959

---

What is schemabinding a view?

906

---

What is the server name in sql server?

986

---