固化视图

1. dns
2.固化视图建立索引会对原表的增删改操作造成影响，需设置 ARITHABORT 为 ON

方法1
ALTER DATABASE kelingtestnew
set arithabort ON

方法2
exec sp_dboption 'kelingtestnew','ARITHABORT','true'

查看 ARITHABORT 状态
select is_arithabort_on ,* from sys.databases

固化视图sql参考
create view [dbo].[SOIsPurchase]
with schemabinding
as

select... from dbo.[table]