SQL Server Table Variables And Cursorless Cursor |
| Printer Friendly Version |
|
|
|
|
|
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 |
| 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 |