Browse by Tags

All Tags » behaviour changes (RSS)
07 March 2009 10:17

Behavior Changes to Database Engine Features in SQL Server 2008

Updated Point on BOL is available at http://msdn.microsoft.com/en-us/library/ms143359.aspx
Posted by Madhivanan | with no comments
Filed under: , ,
20 February 2009 09:26

SQL_VARIANT datatype and behaviour changes

When you use sql_variant datatype in sql server 2000 , and add data to a table using union all, it will work though datatype of data differs from each other declare @test table ( variant_column sql_variant ) insert into @test select 'test' union...
Posted by Madhivanan | 1 comment(s)
Filed under: , ,
12 October 2007 12:05

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...
Posted by Madhivanan | 3 comment(s)
Filed under: ,