Browse by Tags

• Feature
• SQL Server 2005
• SQL Server 2008

• Interesting Bug/Feature In SQL Server 2008 RTM

  Someone had a problem with 8 year old procs which started to fail after moving to SQL Server 2008 Of course he should have used ints, but let's see what happens Run this code on SQL Server 2005 and 2000 DECLARE @num_Passed Numeric ( 2 , 0 ); SET @num_Passed Read More... Posted Monday, August 25, 2008 12:28 PM by Denis Gobo | 3 Comments Filed under: Bug, SQL Server 2008

• INTERCEPT In SQL 2005

  I was writing a query and managed to mistype INTERSECT, I typed INTERCEPT and to my surprise the query ran, it returned 2 result set just as if INTERCEPT wasn't there at all Try it yourself CREATE TABLE testnulls (ID INT ) INSERT INTO testnulls VALUES Read More... Posted Tuesday, November 13, 2007 4:09 PM by Denis Gobo | 21 Comments Filed under: Bug, Feature, SQL Server 2005