CREATE PROCEDURE [dbo].[up_update_individual_room]
	@character_id 		[uniqueidentifier],
	@individual_room_id     int

as 
set nocount on

	update dbo.CharacterTable set  
		individual_roomID = @individual_room_id
		where character_id = @character_id;

return @@error