This script is a simple usage of cursors in MSSQL:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
IF OBJECT_ID('tempdb..#persReg','local') IS NOT NULL drop table #persReg create table #persReg ( idx INT IDENTITY(1, 1), name NVARCHAR(256), sirname NVARCHAR(256), [address] NVARCHAR(256), gender NVARCHAR(256), persno NVARCHAR(64) ) insert into #persReg (name, sirname, [address], gender, persno) VALUES ('Samuel','Jo','Pearl Anchor Bank','0','474-11-2808'); insert into #persReg (name, sirname, [address], gender, persno) VALUES ('Lauren','Ezekiel','Cool Willow Highlands','0','497-38-7431'); insert into #persReg (name, sirname, [address], gender, persno) VALUES ('Kiarra','Ashlea','Lost Fawn Chase','1','497-38-7431'); insert into #persReg (name, sirname, [address], gender, persno) VALUES ('Krystelle','Presly','Auburn Place','1','212-72-6546'); DECLARE @pers_idx INT, @name NVARCHAR(256), @ssn NVARCHAR(64); DECLARE db_cursor CURSOR FOR SELECT idx, name, persno FROM #persReg OPEN db_cursor; FETCH NEXT FROM db_cursor INTO @pers_idx, @name, @ssn; WHILE @@FETCH_STATUS = 0 BEGIN print 'IDX: ' + CONVERT(varchar,@pers_idx) + ' - SSN: ' + @ssn + ' - Name: '+@name; -- Other Navigate Options: Fetch -FIRST, LAST, RELATIVE, ABSOLUTE FETCH NEXT FROM db_cursor INTO @pers_idx, @name, @ssn; END CLOSE db_cursor; DEALLOCATE db_cursor |