CREATE PROCEDURE [dbo].[up_add_inquiry_count] @auth_id uniqueidentifier as set nocount on --declare @inquiry_count tinyint --select @inquiry_count = [InquiryCount] from [RustyHeartsLinkAuth].[RustyHearts_Auth].[dbo].[AuthTable] with (READUNCOMMITTED) where [AuthID] = @auth_id --UPDATE [RustyHeartsLinkAuth].[RustyHearts_Auth].[dbo].[AuthTable] SET [InquiryCount] = @inquiry_count + 1 WHERE [AuthID] = @auth_id return @@error