Koen Verbeeck (11/8/2012)
sanket kokane (11/7/2012)
I got it wrong ...you should mention sql server Version in question .
Sysdatetime () not present in sql 2000 and 2005
So, for which versions do you think the question is meant? Obviously for 2008 and up. There's also a consensus that versions who are no longer supported by Microsoft do not count for Questions of the Day.
+1
Also, if you are testing on an old version no longer under support then at that point you should include version.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events