February 2008 - Posts

• SQL Server 2008 CTP6 takes a day off

  Posted Friday, February 29, 2008 4:55 PM | 1 Comments
  
  

  SQL Server 2008 CTP6 does not work on February 29th. Period. On one hand, it is really nice that Microsoft is releasing Community Technology Previews for its latest SQL Server. It helps developers and DBAs to test their solutions and get familiar Read More by András | 1 Comments | Comment on this post

• Type less in SQL Server 2008 (variable initialization and multiple row inserts)

  Posted Thursday, February 28, 2008 9:34 AM | 2 Comments
  
  

  Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use almost constantly. These are variable initialization and the values clause of insert statements that now accept multiple Read More by András | 2 Comments | Comment on this post

• Can I redeclare a variable in T-SQL? Teaser for SQL Bits

  Posted Friday, February 15, 2008 1:17 PM | 2 Comments
  
  

  Variables in T-SQL behave differently from what people may be used to in languages like C or C#. The scope of a variable is the batch in which it is declared. This may not be intuitive to people who are used to local variables. So let’s look at Read More by András | 2 Comments | Comment on this post