select MAX(item_id) from dbo.SEC_Item
CREATE UNIQUE NONCLUSTERED INDEX FilteredItem_URL ON [SEC_Item]([Brand_ID] ASC,[Item_URLKey] ASC)WHERE item_id>10211817
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
创建唯一索引的时候遇到问题,提示“唯一索引的分区依据列必须是索引键的子集”
最新推荐文章于 2024-07-18 14:22:53 发布