ADVISOR Home Boomer Advisor DataBased Advisor FileMaker Advisor Advisor Basics of FileMaker Pro How-To CDs Advisor Store: Subscriptions & CDs Help
My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
Go to Article
Advanced Search 
Link to DataBased Advisor 
Submit your How To tips and advice 

ADVISOR ANSWERS

Deal with NULLs and Uniqueness in Microsoft SQL Server

How do you apply uniqueness to only non-NULL values? Find out the answer here.

By Richard Campbell, technical editor

THIS ARTICLE IS SUBSCRIBER-ONLY
To read this article you must have a current Subscription or Passport for:
DATABASED ADVISOR
or
MICROSOFT ACCESS ADVISOR
or
MICROSOFT PRO DEVELOPMENT ADVISOR
If you have a correct subscription, sign-in (pink box above) to view the complete article and access any Download.

Purchase or renew your Subscription or Passport at www.AdvisorStore.com.

Click this link for help with subscriber online access.

About this Article:

A reader says that he is required to have a unique constraint on Social Security Numbers, but not all his records have Social Security Numbers, so there are nulls. This is fine when there's only one null, but not more than one -- and he has more than one. Find out how he can remedy this situation.

Keyword Tags: Microsoft, Microsoft SQL Server

ADVISORAMA
Why not give your son a motorcycle for his last birthday?
-- Colin Bowles
Refresh (F5) for more   Contribute

Advisor Solutions

ARTICLE INFO

DataBased Advisor

Web Edition: 2007 Week 38, Doc #19262

Print Edition: October 2007, Page 5

SUBSCRIBER ONLY ARTICLE LOCKED
SUBSCRIPTION STATUS
You are not signed-in. If you are a subscriber to this publication, sign-in above to access locked articles. To subscribe or renew go to www.AdvisorStore.com.

MORE ADVISOR

Advisor on Microsoft

Advisor on Microsoft SQL Server

ARTICLE ACCESS
= free access
= subscriber-only
= not online (on CD or in print)
= has download

DataBased Advisor How-To Library by Topic Keywords

Subscribe to DataBased Advisor Magazine

Get subscriber online access to articles

DataBased Advisor Forum

Free e-newsletters on business, technology & lifestyle

Special Offers

Subscribe to FileMaker Advisor Magazine

Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

FileMaker.Advisor.com

Subscribe to Advisor Basics of FileMaker Pro

Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

FileMaker.AdvisorBasics.com

Showcase Your Smarts

Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

AdvisorTips.com
Site Map Advisor Store Privacy Terms of Use Trademarks Advertising About Advisor Media Advisor's San Diego
ADVISOR NETWORK
Advisor Basics of FileMaker Pro | Boomer Advisor | Business Advisor | Business Collaboration Advisor | Business Security Advisor | Caregiver Advisor | Community Advisor | Compliance Solutions Advisor | Computer Advisor | DataBased Advisor | DataBased Advisor | Dogs Advisor | E-Discovery Advisor | Entertainment Advisor | Family Advisor | FileMaker Advisor | Food Advisor | Fun Advisor | Generations Advisor | Health Advisor | HomeLiving Advisor | IBM Lotus Advisor | IBM WebSphere Advisor | Law Tech Advisor | Lifestyle Advisor | Microsoft Access Advisor | Microsoft Office Advisor | Microsoft Pro Development Advisor | Microsoft SharePoint Advisor | Microsoft Visual Basic .NET Advisor | Microsoft Visual FoxPro Advisor | Microsoft Visual Studio Advisor | Mobile Business Advisor | Money Advisor | Novell GroupWise Advisor | Pets Advisor | Recreation Advisor | Retirement Advisor | RV Advisor | Senior Solutions Advisor | Travel Advisor | Work Advisor
Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Hosted by Prominic.NET Website powered by
LOTUS SOFTWARE
campr200-02 posted 09/17/2007 modified 12/03/2008 03:39:37 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 12/03/2008 05:08:11 PM