Sql fetch cursors
August 13, 2008
DECLARE
slip_Update CURSOR FOR
SELECT * FROM SlipsTEST, SlipdetailsTEST
WHERE SlipsTEST.SlipIdOld = SlipdetailsTEST.SlipIdOld
FOR UPDATE;
BEGIN
OPEN slip_Update;
FOR slip_Update IN slip_Update
LOOP
UPDATE SlipdetailsTEST
SET SlipdetailsTEST.SNO = SlipsTEST.SNO
WHERE CURRENT OF slip_Update;
END LOOP;
CLOSE slip_Update;
END;
Entry Filed under: Database. Tags: author-pinal, data-warehousing, dba, dba-tool, msbuild, sql-add-on, sql-authority, sql-backup-and-restore, sql-data-storage, sql-datetime, sql-documentation, sql-download, sql-query, sql-tips-and-tricks, sqlauthority-news, t-sql, xquery.
Trackback this post | Subscribe to the comments via RSS Feed