/********************************************************************************/
/*		              Company Name                   			*/
/********************************************************************************/
/*      Procedure Name  : dbo.ssp_stored_procname                               */
/*      Parameters      :                                                       */
/*      Return Codes    :                                                       */
/*                                                                              */
/*      Description     : Description of what it does, params etc               */
/*                                                                              */
/*                                                                              */
/*                                                                              */
/*                                                                              */
/*                                                                              */
/*      Author          : Authorname                                            */
/*      Date written    : Date                                                  */
/*      History         : version number                                        */
/*                                                                              */
/********************************************************************************/
 
IF EXISTS (SELECT 1 FROM sysobjects where id = object_id('dbo.ssp_stored_procname') and sysstat & 0xf = 4)
BEGIN
	PRINT 'Dropping old version of dbo.ssp_stored_procname'
	DROP PROCEDURE dbo.ssp_stored_procname
END
GO
 
PRINT 'Creating procedure dbo.ssp_stored_procname - START'
GO
 
CREATE PROCEDURE dbo.ssp_stored_procname
	(@field 	[datatype])

AS
DELETE FROM table
WHERE (conditions = @conditions)

RETURN @@ERROR
GO

PRINT 'Creating procedure dbo.ssp_stored_procname - END'
GO