CREATE PROCEDURE [dbo].[up_insert_inquiry]
	@auth_id				uniqueidentifier,
	@character_id			uniqueidentifier,
	@type					tinyint,
	@character_name			nvarchar(16),
	@bcust_id				nvarchar(50),
	@count					tinyint,
	@memo					nvarchar(255),
	@compulsion				tinyint,
	@registertime			datetime

as
set nocount on

	 if NOT EXISTS (select @character_id from [dbo].[InquiryTable] with (READUNCOMMITTED) where [character_id] = @character_id)
		begin
			insert into InquiryTable
			values
			(
				@auth_id,
				@character_id,
				@type,
				@character_name,
				@bcust_id,
				@count,
				@memo,
				@compulsion,
				@registertime
			);
		end
return @@error