SQL Server Table Variables And Cursorless Cursor

Here's a quick tip that allows you to duplicate the functionality of a cursor without using one in SQL Server 2000.

declare @RowCnt int
declare @MaxRows int
declare @Email nvarchar(255)
declare @rc int

select @RowCnt = 1

declare @Import table
(
rownum int IDENTITY (1, 1) Primary key NOT NULL ,
Email nvarchar(255)
)

insert into @Import (Email) values ('blah@blah.com')
insert into @Import (Email) values ('blahblah@blah.com')

select @MaxRows=count(*) from @Import

while @RowCnt <= @MaxRows
begin

select @rc=0

select @Email = Email
from @Import
where rownum = @RowCnt

print @Email

Select @RowCnt = @RowCnt + 1

end

Submission Date: 3/22/2006 11:18:08 AM

Submitted By: Robbe Morris

Email:

My Home Page: http://www.robbemorris.com

My Biography

Robbe has been a Microsoft MVP for C# since 2004. He is also the co-founder of EggHeadCafe. Robbe has extensive experience with web technologies, .NET, C#, CTI based applications, system administration, .NET Compact Framework, and data modeling. In his spare time, he blogs from time to time at http://robbemorris.blogspot.com