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_assignment2$
|
WHERE $Primary$=@$Primary$
|
|
GO
|
