summaryrefslogtreecommitdiff
path: root/tests/unit/SQLMap/scripts/mssql/category-procedure.sql
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()