07/02/2008
Basit bir Cursor kodu
DECLARE @TableId INT
DECLARE CursorName CURSOR FOR
SELECT TableId FROM Table --WHERE TableId = @TableId
OPEN CursorName
FETCH NEXT FROM CursorName INTO @TableId
WHILE @@FETCH_STATUS =0
BEGIN
FETCH NEXT FROM CursorName INTO @TableId
END
CLOSE CursorName
DEALLOCATE CursorName
14:45 Posted in Sql | Permalink | Comments (0) | Email this | Tags: sql cursor