CREATE procedure [dbo].[up_update_event_inquiry] @auth_id [uniqueidentifier], @inquiry tinyint as begin set nocount on update AuthTable set event_inquiry = @inquiry where AuthID = @auth_id end