How flexible are SQL Server stored procs?

10-26-2004, 04:40 AM

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,


10-26-2004, 05:15 AM
IFs, CASEs, Cursors, Variables and Scheduled jobs are all available in SQL Server :)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum