<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sky22222</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sky22222]]></copyright><item><title><![CDATA[关于SQLSERVER作业『QUOTED_IDENTIFIER』设置不正确的错误]]></title><link>https://blog.youkuaiyun.com/sky22222/article/details/108446295</link><guid>https://blog.youkuaiyun.com/sky22222/article/details/108446295</guid><author>sky22222</author><pubDate>Mon, 07 Sep 2020 13:47:25 +0800</pubDate><description><![CDATA[作业语句：


UPDATE [table]
SET [table].[field] = 0,
WHERE
	[table].[field] = 1

当创建了带筛选条件的索引后：


CREATE UNIQUE NONCLUSTERED INDEX [IX_id_notnull] ON [table] ([field] ASC)
WHERE([field] IS NOT NULL)
WITH (PAD_INDEX = OFF,	STATISTICS_NORECOMPUTE = OFF, SORT_IN_T]]></description><category></category></item></channel></rss>