|
|
|
|
 Click here to copy the following block | create table #t (seq int)
create clustered index t_seq on #t(seq)
go
insert #t values (1)
insert #t values (2)
insert #t values (3)
go
select * from #t
begin tran
declare @seq int
declare origseq insensitive cursor
for select seq from #t
open origseq
while ( 'FETCH IS OK' = 'FETCH IS OK' )
begin
fetch origseq into @seq
if @@fetch_status < 0 break
update #t
set seq = @seq + 10
where seq = @seq
end
deallocate origseq
select * from #t
rollback
go
drop table #t
go |
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|