CREATE PROCEDURE [dbo].[up_delete_buff]
@character_id			uniqueidentifier,
@buff_type				int,
@buff_id				int

as 
set nocount on
	delete dbo.BuffTable where character_id = @character_id and	buff_id = @buff_id and buff_type = @buff_type

return @@error