/********************************************************************************/
/*		              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](datasize),
	 @field 	[datatype],
	 @field		[datatype](datasize),
	 @field		[datatype](datasize),
	 @field		[datatype],
	 @field		[datatype])

AS UPDATE tablename 

SET  [field]	 = @field, 
     [field]	 = @field,
     [field]	 = @field,
     [field]	 = @field,
     [field]	 = @field

WHERE 
	( [field] = @conditions)

RETURN @@ERROR
GO

PRINT 'Creating procedure dbo.ssp_stored_procname - END'
GO