27 lines
629 B
Transact-SQL
27 lines
629 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_skill_reset]
|
|
@character_id [uniqueidentifier]
|
|
as
|
|
set nocount on
|
|
|
|
begin tran
|
|
|
|
declare @TempSP int
|
|
set @TempSP = -1
|
|
--스킬 삭제 후, Total SP -> SP 설정
|
|
delete SkillTable where character_id = @character_id and [use] = 1
|
|
|
|
select @TempSP = Total_SP from CharacterTable with (READUNCOMMITTED) where character_id = @character_id
|
|
|
|
update CharacterTable set SP = @TempSP where character_id = @character_id
|
|
|
|
declare @ERR int
|
|
|
|
SET @ERR = @@ERROR
|
|
IF @ERR <> 0 BEGIN
|
|
RAISERROR('처리오류', 16, 10)
|
|
IF @@TRANCOUNT <> 0 ROLLBACK
|
|
RETURN (@ERR)
|
|
END
|
|
COMMIT TRAN
|
|
|
|
return @@error
|