var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: delete a stored proc
Hi everyone -
What is the syntax to drop a stored procedure?
In my script, i would like to delete the existing
stored proc prior to creating a new one...
That was the ticket -
if exists(select * from sysobjects where type = 'P' and name = 'xprocDischargePatientByClass') drop procedure xprocDischargePatientByClass;
thanks for the post!!
Last edited by alt-088; 10-20-05 at 10:57.