Polly013
10-26-2004, 04:40 AM
Hi,
Just a quick question. In the past I have used Oracle PL/SQL to write procedures to do all sorts of things. It is possible to use if statements and loops and variables etc to manipulate your data however you want. I just want to know if this is possible in a SQL Server stored procedure? I'm trying to write one but the more I get into it the more I realise it is going to need variables to store info in, a cursor that can be looped around and some if statements. Is this feasible or should I be writing this in vb or something? I'd like to be able to schedule the script in SQL Server to run regularly.
Any help appreciated,
Thanks,
Paula.
Just a quick question. In the past I have used Oracle PL/SQL to write procedures to do all sorts of things. It is possible to use if statements and loops and variables etc to manipulate your data however you want. I just want to know if this is possible in a SQL Server stored procedure? I'm trying to write one but the more I get into it the more I realise it is going to need variables to store info in, a cursor that can be looped around and some if statements. Is this feasible or should I be writing this in vb or something? I'd like to be able to schedule the script in SQL Server to run regularly.
Any help appreciated,
Thanks,
Paula.