On TechRepublic: 12 tech terms that make you sound old
BNET Business Network:
BNET
TechRepublic
ZDNet

FREE Registration is required

Overview:

Even simple errors in data can result in huge problems. Luckily, you can eliminate at least some of those errors by using CHECK constraints to force users to enter data that meets specific conditions.

Database expert Susan Harkins explains this approach and then walks through an example demonstrating how to create a constraint that allows a ZIP code column to accept only five numeric digits.

This download is also available as an article. Join the discussion and share your experiences and opinions.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format:PDFSize:135 KB
Date:Mar 2007Version:1.0
License:copyright
System Req:Adobe Acrobat Reader 5.0 or later

People who downloaded this item also downloaded

Download The five fundamentals of IT consulting
Download 10 reasons why IT pros hate Microsoft Access (but really shouldn't)
Download 10 ways to prevent Access database corruption
Download 10 reasons to explicitly convert SQL Server data types
Download 10+ tips for designing flexible and efficient Access tables

Top results from Database Applications

White Paper Data Warehousing with DB2 for System z
Case Study European Finance Employees Build Stronger Business Relationships With Management Tool
White Paper Microsoft Dynamics CRM 4.0: Performance and Scalability - Database Scalability for the Enterprise
White Paper Adaptive ServerŪ Enterprise (ASE) Cluster Edition: Higher Application Service Levels at a Lower Cost
White Paper Troubleshooting SQL 2005: Opening the Database Administrator's Toolbox

» View all Database Applications listings

advertisement

White Papers, Webcasts, and Resources

Featured Training Courses

advertisement

Enterprise Applications

  • Check out some of the easiest and most powerful ways to boost productivity while saving money on your application infrastructure. See ZDNet's comprehensive Enterprise Application resource center, now!
  • New Online Dashboard
  • Read about top issues IT decision-makers face every day, plus get cost effective solutions to real life IT problems. Oracle Topline

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this library, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the ZDNet white paper newsletter and e-mail Must-Read News Alerts. You can unsubscribe from these at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).