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 is create statement?

888

---

What is Federation and Federation Member?

92

---

What are the dmvs? : sql server database administration

1004

---

What does ss stand for sexually?

1010

---

Distinguish between commit and rollback?

899

---

How would you go about developing a ssrs report?

158

---

Explain the third normal form(3nf)?

893

---

please differentiate between delete and truncate?

942

---

What is the maximum size of a row in sql server?

905

---

How to make a column nullable?

1038

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

985

---

Does a full backup include transaction log?

907

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

Can we write ddl in trigger?

865

---

How to skip remaining statements in a loop block using continue statements?

931

---