declare @CurrentRow int
declare @TotalRows int
declare @FirstName nvarchar(255)
select @CurrentRow = 1
declare @TableVariable table
(
UniqueRowID int IDENTITY (1, 1) Primary key NOT NULL ,
FirstName nvarchar(255)
)
insert into @TableVariable (FirstName) values ('Adam')
insert into @TableVariable (FirstName) values ('Bill')
insert into @TableVariable (FirstName) values ('Charlie')
insert into @TableVariable (FirstName) values ('Dennis')
select @TotalRows=count(*) from @TableVariable
while @CurrentRow <= @TotalRows
begin
select @FirstName = FirstName
from @TableVariable
where UniqueRowID = @CurrentRow
print @FirstName
select @CurrentRow = @CurrentRow + 1
end
Tuesday, 19 December 2006
Cursor functionality via table variable and loop
-- cursor functionality WITHOUT using a cursor
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment