blob: 45fcda2c98c4e443934ca9aa9c333f488bf912d8 (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE PROCEDURE dbo.[ps_InsertCategorie]
@Category_Id [int] output,
@Category_Name [varchar] (32),
@Category_Guid [uniqueidentifier]
AS
insert into Categories
(Category_Name, Category_Guid )
values
(@Category_Name, @Category_Guid)
SELECT @Category_Id = SCOPE_IDENTITY()
|