6,129
社区成员
发帖
与我相关
我的任务
分享
create --drop
table x(a int,b int ,c int )
go
create --drop
view v_test
with schemabinding
as
select a,b ,count_big(*) c from dbo.x group by a,b
go
create unique clustered index x on v_test(a,b)
go
select * from v_test
select @@version
/*
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 6.0 (Build 6000: )
*/