21 lines
432 B
Transact-SQL
21 lines
432 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_insert_buff]
|
|
@character_id uniqueidentifier,
|
|
@type int,
|
|
@id int,
|
|
@time int
|
|
|
|
as
|
|
set nocount on
|
|
|
|
if NOT EXISTS (select @character_id from [dbo].[BuffTable] with (READUNCOMMITTED) where [character_id] = @character_id and [buff_type] = @type and [buff_id] = @id )
|
|
begin
|
|
insert into BuffTable
|
|
values
|
|
(
|
|
@character_id,
|
|
@type,
|
|
@id,
|
|
@time
|
|
);
|
|
end
|
|
return @@error
|