Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
create table Catch22(rowid int identity(1,1), data varchar(80)) GO insert into Catch22 select 'abc' insert into Catch22 select 'yyz' insert into Catch22 select 'pdq' insert into Catch22 select 'xyz' insert into Catch22 select 'cat' GO create view vCatch22 as select top 100 rowid, data from Catch22 order by data GO select * from vCatch22 GO ------ The above works as expected, but using top PERCENT below does not ... why? ------- alter view vCatch22 as select top 100 PERCENT rowid, data from Catch22 order by data GO select * from vCatch22 GO -- create unique clustered index x1 on Catch22(data,rowid) -- this works, but is not applicable in my real scenario drop view vCatch22 truncate table Catch22 drop table Catch22 --
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.