File tree Expand file tree Collapse file tree 3 files changed +21
-21
lines changed
IBatisNet.DataMapper.Test/Scripts/SQLite3 Expand file tree Collapse file tree 3 files changed +21
-21
lines changed Original file line number Diff line number Diff line change 1
- CREATE PROCEDURE dbo.[ps_InsertCategorie]
2
- @Category_Id [int ] output,
3
- @Category_Name [varchar ] (32 ),
4
- @Category_Guid [uniqueidentifier]
5
- AS
6
- insert into Categories
7
- (Category_Name, Category_Guid )
8
- values
9
- (@Category_Name, @Category_Guid)
10
- SELECT @Category_Id = SCOPE_IDENTITY()
1
+ -- CREATE PROCEDURE dbo.[ps_InsertCategorie]
2
+ -- @Category_Id [int] output,
3
+ -- @Category_Name [varchar] (32),
4
+ -- @Category_Guid [uniqueidentifier]
5
+ -- AS
6
+ -- insert into Categories
7
+ -- (Category_Name, Category_Guid )
8
+ -- values
9
+ -- (@Category_Name, @Category_Guid)
10
+ -- SELECT @Category_Id = SCOPE_IDENTITY()
Original file line number Diff line number Diff line change 1
- CREATE PROCEDURE dbo.[ps_InsertCategorieWithReturnValue]
2
- @Category_Id [int ] output,
3
- @Category_Name [varchar ] (32 ),
4
- @Category_Guid [uniqueidentifier]
5
- AS
6
- insert into Categories
7
- (Category_Name, Category_Guid )
8
- values
9
- (@Category_Name, @Category_Guid)
10
- set @Category_Id = SCOPE_IDENTITY()
11
- return @Category_Id
1
+ -- CREATE PROCEDURE dbo.[ps_InsertCategorieWithReturnValue]
2
+ -- @Category_Id [int] output,
3
+ -- @Category_Name [varchar] (32),
4
+ -- @Category_Guid [uniqueidentifier]
5
+ -- AS
6
+ -- insert into Categories
7
+ -- (Category_Name, Category_Guid )
8
+ -- values
9
+ -- (@Category_Name, @Category_Guid)
10
+ -- set @Category_Id = SCOPE_IDENTITY()
11
+ -- return @Category_Id
12
12
You can’t perform that action at this time.
0 commit comments