SQL-Cursor
| ID | 57 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | T-SQL |
| PlGroup | Datenbank |
| PlItemTitle | SQL-Cursor |
| Code | CREATE #myTempTable ( ID Int IDENTITY ,tempField1 Int ,tempField2 VarChar(30) ) DECLARE @field1 AS Int DECLARE @field2 AS VarChar(30) DECLARE myCursor CURSOR FOR SELECT myTableField1, myTableField2 FROM myTable OPEN myCursor FETCH NEXT FROM myCursor INTO @field1, @field2; WHILE @@FETCH_STATUS=0 BEGIN PRINT @field1 -- Prints value from column myTable.myTableField1 PRINT @field2 -- Prints value from column myTable.myTableField2 INSERT INTO #myTempTable (tempField1,tempField2) VALUES (@field1, @field2) -- do something else... FETCH NEXT FROM myCursor INTO @field1, @field2; -- next row END CLOSE myCursor DEALLOCATE myCursor DROP #myTempTable |
| Result Example |