|
|
Posted by Erland Sommarskog on 09/20/06 07:00
Alexander Kuznetsov (AK_TIREDOFSPAM@hotmail.COM) writes:
> I did a quick benchmarking. I always knew that DATEDIFF approach should
> be faster than converting to CHAR, but I had no idea it is that faster:
Yeah, I know. Other people has been suggesting that as well. I just keep
looking it and saying to myself "what on earth does that do?".
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|