31 lines
649 B
Transact-SQL
31 lines
649 B
Transact-SQL
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
|