THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » t-sql » Constraints   (RSS)
  • Utility Queries–Column Metadata

    Very often, I find myself wanting to query system metadata for columns. Some of the metadata is fairly easy to deal with, like if you want to find column names, just simply querying sys.columns is very straightforward.  But if you want to query data types, it gets stickier.  There are type types listed, one that is the declared type, and ...
    Posted to Louis Davidson (Weblog) by drsql on April 22, 2012
  • Denali Enhancement–Duplicate Key Error Message

    When I was editing my chapter on implementing a database, I noticed a really nice improvement in the error message I had from the previous edition of the book. Instead of just telling me that there was a value in my modification statement that duplicated an existing value (or multiple values affected by the statement), it told me the duplicated ...
    Posted to Louis Davidson (Weblog) by drsql on July 14, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement