SQL Server 创建唯一键索引,允许为空和空字符串的重复
CREATE UNIQUE INDEX [indexname] ON [dbo].[tablename]
([columnname] ASC)
WHERE columnname IS NOT NULL and columnname!= ''
GO
SQL Server 创建唯一键索引,允许为空和空字符串的重复
CREATE UNIQUE INDEX [indexname] ON [dbo].[tablename]
([columnname] ASC)
WHERE columnname IS NOT NULL and columnname!= ''
GO