My Personal Blog's
Posts tagged cursor
Microsoft SQL Server 2005 Cursor Example
May 19th
DECLARE @id INT
DECLARE @name varchar(25)
DECLARE db_cursor CURSOR FOR
SELECT id,name From myTable
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @id, @name
WHILE @@FETCH_STATUS = 0
BEGIN
– do something
FETCH NEXT FROM db_cursor INTO @id, @name
END
CLOSE db_cursor
DEALLOCATE db_cursor
