Behaviour Changes in SQL Server 2005

If you run the following query in both SQL Server 2000 and 2005 , you can see the difference


select random,random,random
from
(
         select rand() as random
) as t

Those behaviour changes are documented here

http://msdn2.microsoft.com/en-us/library/ms143359.aspx

 

Published Friday, October 12, 2007 12:05 PM by Madhivanan

Comments

# SQL_VARIANT datatype and behaviour changes

Friday, February 20, 2009 9:31 AM by Madhivanan

When you use sql_variant datatype in sql server 2000 , and add data to a table using union all, it will

# SQL_VARIANT datatype and behaviour changes

Friday, February 20, 2009 9:47 AM by SQL Server Transact-SQL (SSQA.net)

When you use sql_variant datatype in sql server 2000 , and add data to a table using union all, it will

# SQL_VARIANT datatype and behaviour changes

Monday, February 1, 2010 10:40 AM by Madhivanan's TSQL Blog

When you use sql_variant datatype in sql server 2000, and add data to a table using union all, it will