Cursor building will not be done, wait online, thank you ~

sinexe

--Usage of cursor
DECLARE pivot_Cursor CURSOR FOR
select a from pivot
OPEN pivot_Cursor

FETCH NEXT FROM pivot_Cursor into @a
WHILE @@FETCH_STATUS = 0
BEGIN
...
FETCH NEXT FROM pivot_Cursor into @a
END

CLOSE pivot_Cursor
DEALLOCATE pivot_Cursor

sinexe

--Usage of cursor
DECLARE pivot_Cursor CURSOR FOR
select a from pivot
OPEN pivot_Cursor

FETCH NEXT FROM pivot_Cursor into @a
WHILE @@FETCH_STATUS = 0
BEGIN
...
FETCH NEXT FROM pivot_Cursor into @a
END

CLOSE pivot_Cursor
DEALLOCATE pivot_Cursor

lehmann

:)
I just don’t know how to read data line by line,
Read the specific column or columns of data read into the variable,
Reprocess
I have seen the definition

sinexe

DECLARE pivot_Cursor CURSOR FOR
select a, b from pivot--This is the result set to be traversed with the cursor
OPEN pivot_Cursor

FETCH NEXT FROM pivot_Cursor into @a,@b--This is to get the first record, and assign the record column to the variable
WHILE @@FETCH_STATUS = 0--This is to determine whether there is any data behind
BEGIN
...--This is dealing with
FETCH NEXT FROM pivot_Cursor into @a--this is the next record
END

CLOSE pivot_Cursor
DEALLOCATE pivot_Cursor

lehmann

I want to get all records

shitgeb

It is best not to use cursors

fenghui1231

mark