Hi,
I have a problem with a porting of a cursor structure in Oracle in SQL
Server 2000.
I need the same implementation of the functionalities.
The Oracle cursor structure is:

CURSOR SELECTOR_PHY_DISK IS
SELECT *
FROM DBS_PHYSICAL_DISKS
WHERE DBS_PHYSICAL_DISKS.PHYSICAL_DISK_ID = DISK_ID_P
FOR UPDATE;
physical_disk SELECTOR_PHY_DISK%ROWTYPE;

then I have an INSERT code, some like this:

.......etc...........
VALUES(physical_disk.physical_disk_id,
physical_disk.use,
physical_disk.type,
............etc......

But I've no idea how to write the same in T-SQL (maybe of varchar
type, but then I can't take the structure in the INSERT).
Have anyone ideas?
thanks

Hi

Depending on what you have to do between the fetch and the insert, you will
either have to declare a variable for each column or you may be able to use

INSERT INTO NewTable ( col1, col2... )
SELECT physical_disk_id,
physical_disk.use,
physical_disk.type,...
FROM physical_disk

For examples of a cursor see books online "Declare Cursor" topic.

John

"Gigio" <zambetti (AT) inwind (DOT) it> wrote