pvsbandi
asked on
Advantage of cursor
Hi,
I have to insert rows, generated from an SQL statement into a table.
I thought of Insert into <table_name> select ...
But some existing procedures, are using cursor and loop to insert into the tables.
Why do i need to use a cursor, when i can use an insert into select?
Please advise.
I have to insert rows, generated from an SQL statement into a table.
I thought of Insert into <table_name> select ...
But some existing procedures, are using cursor and loop to insert into the tables.
Why do i need to use a cursor, when i can use an insert into select?
Please advise.
You need to get it removed yourself. See the 'Request Attention' link
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks much for the insight!
ASKER