-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
set quoted_identifier on
go
set arithabort on
go
select * from t1
go
create view v1 with schemabinding as select f1,f2 from dbo.t1
go
select * from v1
go
create unique clustered index ixv1f1 on v1(f1)
go
select * from v1
go
drop view v1
go
