--- In [email protected], Benjamin Scott <[EMAIL PROTECTED]> wrote: > > I use Sql Server Express 7 and it provide you with a > new procedure query. You may want to dowload it for free.
The big point is that due to constraints out of the OP's influence (such as that he might be working for clients using SQLServer 7 and not SQLServer Express) this might not be a viable solution. So the 1-mio $ question is: how to do it in SQLServer 7? A general issue I would like to point out here is that IF SQLServer behaves reasonably (yes, I know, it's a MS product, but still I have hope for mankind ;-) ) you will always have a SQL statement such as CREATE OR REPLACE PROCEDURE myproc(...) This is Oracle syntax, but I'm pretty sure that SQLServer has something similar. Even though I know for sure (have had this experience one year ago in my current project) that SQLServer people do not always use ANSI SQL but tend to using MS SQL... A general advice for all those Windows addicts around (and this is not meant as an insult): if you don't find some particular functionality in a menu or a context menu, try looking up the manuals. Sometimes this helps. And CREATE PROCEDURE is pretty much standard SQL for many a year. Regards, Nico
