在学习SQL Server过程中整理的T-SQL语句

				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