Hi
can we write multiple SQLs in a single CLOSE COMMAND
my requirement is there are updates and delete on the table and the SQLs are like....
1)update table_name set..... left join on table_name2 .....
2)DELETE FROM TABLE_NAME LEFT JOIN TABLE_NAME2 ....WHERE.....
3)update table_name set..... inner join on table_name3 .....
etc.,
so these should be execited one by one.
so is it possible in any way?
is there any other option to do like so?
Thanks
Praveen
CLOSE COMMAND
Moderators: chulett, rschirm, roy
CLOSE COMMAND
Last edited by jpraveen on Thu Sep 09, 2010 6:24 am, edited 4 times in total.
Re: CLOSE COMMAND
I have not tried in parallel, but think you can. The same works in Server After SQL.jpraveen wrote:can we write multiple SQLs in a single CLOSE COMMAND