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 |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2005-08-22 : 08:17:46
|
| I'm sorry, I bet you get asked this ten times a day but I can't find the answer, In Access, you can make a field have a requirement for a unique entry, BUT it allows as many Nulls as you want (i.e. only check for Uniqueness if there is an entry).How do you mimic this behaviour in SQL Server? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-22 : 08:23:03
|
| see this....http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48614&SearchTerms=null,keyespecially AndyB13....entry #4 from the top. |
 |
|
|
|
|
|
Null/Unique