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 |