1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| 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
|
|
