NULLs and Table Constraints

  • Mike McQuillan

Abstract

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:

Keywords

Phone Number Unique Constraint Error Message Empty String Query Window 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Mike McQuillan 2015

Authors and Affiliations

  • Mike McQuillan
    • 1
  1. 1.WinsfordUK

Personalised recommendations