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