blogs.conchango.com

Browse by Tags

• Grouping Sets
• katmai

• Katmai: T-SQL Grouping sets

  SQL Server 2005 includes the WITH CUBE and WITH ROLLUP syntaxes that are used to display summary information for combinations of columns in the GROUP BY clause. That's useful functionality but it didn't provide particularly fine-grained control Read More... Posted 04 June 2007 02:03 by jamie.thomson | 1 Comments Filed under: SQL Server, Microsoft, T-SQL, katmai, Grouping Sets, sqL server 2008

• Katmai: New T-SQL enhancements

  A very short post here showing some of the new T-SQL constructs in katmai . Check out the following code snippet: declare @i int = 1; set @i += 1; create table t1 (col1 int ); insert t1 values (@i),(@i+1); There are actually three syntax enhancements Read More... Posted 04 June 2007 02:03 by jamie.thomson | 4 Comments Filed under: SQL Server, Microsoft, T-SQL, katmai, sqL server 2008