Click here to Skip to main content
15,740,580 members
Home / Discussions / Database
   

Database

 
QuestionSql server: create table with column that support unique and multiple nulls Pin
w1424323-May-17 20:03
w1424323-May-17 20:03 
AnswerRe: Sql server: create table with column that support unique and multiple nulls Pin
Maciej Los23-May-17 20:27
mveMaciej Los23-May-17 20:27 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
w1424323-May-17 20:45
w1424323-May-17 20:45 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
Richard Deeming24-May-17 8:22
mveRichard Deeming24-May-17 8:22 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
w1424324-May-17 17:32
w1424324-May-17 17:32 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
Richard Deeming25-May-17 0:51
mveRichard Deeming25-May-17 0:51 
AnswerRe: Sql server: create table with column that support unique and multiple nulls Pin
ZurdoDev24-May-17 3:15
professionalZurdoDev24-May-17 3:15 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
Richard Deeming24-May-17 8:19
mveRichard Deeming24-May-17 8:19 
RyanDev wrote:
You have custom logic that SQL does not support.

Are you sure about that? Poke tongue | ;-P

A filtered unique index can get you around the problem, like this:
CREATE UNIQUE INDEX uq_UsersAllowNulls_DisplayName on dbo.UsersAllowNulls ( DisplayName )
    WHERE DisplayName IS NOT NULL;
GO




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
ZurdoDev24-May-17 8:24
professionalZurdoDev24-May-17 8:24 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
w1424324-May-17 17:45
w1424324-May-17 17:45 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
ZurdoDev25-May-17 0:49
professionalZurdoDev25-May-17 0:49 
QuestionDisplay data only from search parameters Pin
rattlerrFx23-May-17 7:16
rattlerrFx23-May-17 7:16 
QuestionRe: Display data only from search parameters Pin
CHill6023-May-17 10:52
mveCHill6023-May-17 10:52 
AnswerRe: Display data only from search parameters Pin
rattlerrFx23-May-17 13:21
rattlerrFx23-May-17 13:21 
GeneralRe: Display data only from search parameters Pin
CHill6024-May-17 1:06
mveCHill6024-May-17 1:06 
QuestionTeam Please help on the below request Pin
ganesh_naganna23-May-17 0:55
ganesh_naganna23-May-17 0:55 
AnswerRe: Team Please help on the below request Pin
Mycroft Holmes23-May-17 14:55
professionalMycroft Holmes23-May-17 14:55 
QuestionSQL for dynamic mappings Pin
Danpeking22-May-17 3:13
Danpeking22-May-17 3:13 
QuestionRe: SQL for dynamic mappings Pin
CHill6022-May-17 4:19
mveCHill6022-May-17 4:19 
AnswerRe: SQL for dynamic mappings Pin
Danpeking22-May-17 4:30
Danpeking22-May-17 4:30 
AnswerRe: SQL for dynamic mappings Pin
CHill6022-May-17 4:27
mveCHill6022-May-17 4:27 
GeneralRe: SQL for dynamic mappings Pin
Danpeking22-May-17 4:36
Danpeking22-May-17 4:36 
GeneralRe: SQL for dynamic mappings Pin
CHill6022-May-17 4:39
mveCHill6022-May-17 4:39 
GeneralRe: SQL for dynamic mappings Pin
Danpeking22-May-17 5:46
Danpeking22-May-17 5:46 
AnswerRe: SQL for dynamic mappings Pin
Danpeking24-May-17 23:28
Danpeking24-May-17 23:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.