IF EXISTS ( SELECT 1 FROM dbo.sysobjects WHERE id = object_id(N'[$AddProcName$]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) 
  DROP PROCEDURE [$AddProcName$] 
GO 
------------------------------------ 
--ÓÃ;£ºÔö¼ÓÒ»Ìõ$ChinaComment$¼Ç¼
--˵Ã÷£º 
--×÷Õß: $Author$ 
--ʱ¼ä£º$CurDate$ 
------------------------------------ 
CREATE PROCEDURE $AddProcName$
	@id int output,
	$insert_cols_params$
AS 
	INSERT INTO [$TableName$](
	$insert_cols$
	)VALUES(
	$insert_cols_values$
	)
	SET @id = @@IDENTITY
	RETURN @id
GO