Esoteric

The inside scoop on SQL / debugging you won't find anywhere else!
Posts
  • Esoteric

    T-SQL formatter: a PowerShell script

    • 0 Comments
    This is a ‘quick-and-not-so-dirty’ version of a T-SQL formatter / ‘pretty printer’ in PowerShell. To use this, please install the SQL 2012 SP1 version of the SQLDOM from the Feature Pack page . (If you already have SQL 2012 client tools on your machine...
  • Esoteric

    Named constraints: two sides to the story!

    • 3 Comments
    Background Constraints in SQL Server are of the following types: CHECK constraints DEFAULT constraints Foreign key constraints NULLable constraint UNIQUE constraint PRIMARY KEY constraint BTW, if you are wondering what a NULLable constraint is, it is...
Page 1 of 1 (2 items)

February, 2013