Solved

Referential Integrity

Posted on 1998-10-08
1
202 Views
Last Modified: 2010-03-19
I have created a link between tables by foreign key. I may have to leave this foreign key value blank ( as there might not be a valid entry for this field) . At the moment referential integrity is forcing me to not leave this foreign key value blank. Because I have a foreign key declared does this mean that I have to enter a value here. ??????????
0
Comment
Question by:calis
1 Comment
 
LVL 1

Accepted Solution

by:
kdimmock earned 50 total points
ID: 1090452
Blank?  Try NULL (the reserved word, not a string!).  Make sure the column is "nullable".  It should work.

insert into table1 values('A',Null)
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question