Browse by Tags

• Transact SQL

• Yet another gotcha: variables' scopes do not end where they should.

  Be careful: unlike most other languages, T-SQL does not limit variables' scope to the block where the variable has been defined. For example, the following snippet compiles and runs: -- @to is not in scope yet -- the line below would not compile --SET Read More... Posted Wednesday, January 25, 2012 5:09 PM by Alexander Kuznetsov | 11 Comments Filed under: Transact SQL, consistency

• A foolish consistency is the hobgoblin of little minds?

  In the following script one out of six semicolons does not parse. Can you guess which one we need to remove without running it or scrolling down for the answer? Does it make sense to you? BEGIN TRY ; PRINT 'Inside TRY' ; END TRY ; BEGIN CATCH ; PRINT Read More... Posted Tuesday, February 16, 2010 2:02 PM by Alexander Kuznetsov | 9 Comments Filed under: Transact SQL, consistency