36 lines
776 B
Transact-SQL
36 lines
776 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_guild_member_remove]
|
|
@guild_id [uniqueidentifier],
|
|
@character_id [uniqueidentifier]
|
|
AS
|
|
BEGIN
|
|
|
|
SET NOCOUNT ON;
|
|
SET XACT_ABORT ON;
|
|
|
|
DECLARE @result_code INT;
|
|
|
|
SET @result_code = 1; --1 : 성공 / -1 : 프로시저 오류 / -2 : INSERT 실패 / -3 : UPDATE 실패
|
|
|
|
BEGIN TRY
|
|
|
|
BEGIN TRAN;
|
|
|
|
DELETE FROM dbo.GuildMemberTable WHERE guild_id = @guild_id and character_id = @character_id
|
|
|
|
--탈퇴/삭제된 유저의 길드포인트는 0으로 변경 jojo
|
|
UPDATE [dbo].[CharacterTable] SET [GuildID] = NULL, [GuildPoint] = 0 WHERE [character_id] = @character_id
|
|
|
|
COMMIT TRAN;
|
|
|
|
SELECT result_code = @result_code; --결과 코드 전달
|
|
|
|
END TRY
|
|
BEGIN CATCH
|
|
|
|
ROLLBACK TRAN;
|
|
|
|
SELECT result_code = -1;
|
|
|
|
END CATCH
|
|
|
|
END
|