Skip to content

Commit a8892db

Browse files
author
mikhaild908@gmail.com
committed
SQLite3 does not support stored procs
1 parent b15b15b commit a8892db

File tree

3 files changed

+21
-21
lines changed

3 files changed

+21
-21
lines changed
Lines changed: 10 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,10 @@
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()
Lines changed: 11 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,12 +1,12 @@
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
1212

src/IBatisNet.Net45.2012.v11.suo

-82.5 KB
Binary file not shown.

0 commit comments

Comments
 (0)