USE [ConferenceFinal]
GO

/****** Object:  StoredProcedure [dbo].[addWorkshop]    Script Date: 19.01.2017 23:46:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[addWorkshop]
    @name varchar(50),
    @description varchar(5000) = NULL,
    @participants_limit smallint,
    @price money
AS
	SET NOCOUNT ON
	SET XACT_ABORT ON

	BEGIN TRAN

	INSERT INTO [dbo].[Workshop] ([name], [description], [participants_limit], [price])
	SELECT @name, @description, @participants_limit, @price

	COMMIT

GO