添加列:
ALTER TABLE tablename ADD okcolumn AS CASE WHEN NewsUrl<>'' AND IsDeleted=0 AND IsVerify=1 AND IsUserPost=0 THEN 1 ELSE 0 END PERSISTED;
PERSISTED 将列标记为持久化的。如果决定要使用PERSISTED时,必须判断列是否是精确的,通过下面查询判断:
SELECT COLUMNPROPERTY(object_id('tablename'), 'okcolumn', 'IsPrecise');
要创建索引的列必须是具有确定性的,使用下面语句查询列是否具有确实性:
SELECT COLUMNPROPERTY(object_id('tablename'), 'okcolumn', 'IsDeterministic');