create view view3 with schemabinding.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 14 行

use test
go
create view view3 with schemabinding 
as
select sname,score
       from dbo.XS,dbo.XS_KC
       where dbo.XS.sno=dbo.XS_KC.sno
go
set numeric_roundabort off
set ansi_padding,ansi_warnings,concat_null_yields_null,arithabort,quoted_identifier,ansi_nulls on

create unique clustered index Inx1 on view3(sname)
go