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

Explain the concept of view and Types of views in SQL server?

1034

---

Do you know the policy based administration feature of sql server 2008?

998

---

Difference between DELETE and TRUNCATE?

1094

---

Difference between report and query parameter. Why do we need different type of parameter?

1007

---

Explain syntax for disabling triggers?

1093

---

How to send email from database?

1069

---

Will sql server 2005 allow you to reduce the size of a column?

1054

---

What is the boxing and unboxing concept in .net?

974

---

What happens to a trigger with multiple affected rows?

993

---

Difference between drill down and drill through report.

1003

---

Is sql server is free?

1017

---

What are the tool windows in sql server management studio? : sql server management studio

1121

---

Explain about SQLOS?

1057

---

How to use union to merge outputs from two queries together in ms sql server?

1134

---

Explain optimistic and pessimistic concurrency?

1031

---