IF EXISTS ( SELECT 1 FROM dbo.sysobjects WHERE id = object_id(N'[$UpdateProcName$]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1) 
  DROP PROCEDURE [$UpdateProcName$] 
GO 
------------------------------------ 
--ÓÃ;£ºÐÞ¸ÄÒ»Ìõ$ChinaComment$¼Ç¼
--˵Ã÷£º 
--×÷Õß: $Author$ 
--ʱ¼ä£º$CurDate$ 
------------------------------------ 
CREATE PROCEDURE $UpdateProcName$
	$update_cols_params$
AS 
	UPDATE [$TableName$] SET 
	$update_cols_assignment$
	WHERE $Primary$=@$Primary$ 

GO