Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-14 : 10:03:40
|
Anand writes "I have a table which captures patient data. there are 24 fields and the primary key is that of the Patient id
ther are three fields called PESEL,Tax Id and Passport no
they have to be unique and can be nullable.
but MS SQL server 7.0 doesnt accept multiple null values for unique fields.for eg: a person might not have a passport no..so for the first time it asccepts
if ther is another person who doessnt have a passport no . it throws a sql error
PLease advice as to how to solve the problem
In the msdn, it has been clearly stated that unique can be nullable in the actual scenario it does allow null..not multiple null..how do i solve this problem." |
|
|
|
|
|
Multiple field with Unique keys and the field allows nulls