NULLs and Table Constraints

  • Mike McQuillan


You’ve done brilliantly. You’ve created an entire database with a normalized table structure. You’ve even created specialized scripts so you can build or drop the database easily. Now we’re going to look at how we can help to ensure—as far as we can—that only good data is entered into our tables. As you might imagine, SQL Server provides a few tools that can help. We’re going to look at the following:


Phone Number Unique Constraint Error Message Empty String Query Window 

Copyright information

© Mike McQuillan 2015

Authors and Affiliations

  • Mike McQuillan
    • 1
  1. 1.WinsfordUK

Personalised recommendations