USE [ConferenceFinal]
GO

/****** Object:  StoredProcedure [dbo].[updateWorkshop]    Script Date: 19.01.2017 23:47:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

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

	BEGIN TRAN

	UPDATE [dbo].[Workshop]
	SET    [name] = @name, [description] = @description, [participants_limit] = @participants_limit, [price] = @price
	WHERE  [id] = @id

	COMMIT

GO