With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
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 --
|Changing multiple SQL login passwords||9||32|
|Sql Server 2008 R2 Stored Procedure doesn't work with CTE and parameters||4||31|
|SQL Server CASE .. WHEN .. IN statement - Syntax issue||4||51|
|sql query questions||2||25|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!