69 lines
1.4 KiB
Transact-SQL
69 lines
1.4 KiB
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_practice_Init_count] Script Date: 2017-12-07 오후 6:59:20 ******/
|
|
DROP PROCEDURE [dbo].[game_practice_Init_count]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_practice_Init_count] Script Date: 2017-12-07 오후 6:59:20 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
--IF OBJECT_ID('dbo.game_practice_get_list','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.game_practice_get_list
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.game_practice_get_list
|
|
-- DBA :
|
|
-- DATE : 2014-03-03
|
|
-- Description : 훈련하기 데이터
|
|
-- =============================================
|
|
|
|
Create PROCEDURE [dbo].[game_practice_Init_count]
|
|
|
|
@ACCOUNT_IDX INT,
|
|
@PRACTICE_IDX INT, -- 연습 인덱스
|
|
@PRACTICE_COUNT INT -- 수련장 입장횟수
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
SELECT COUNT(*) FROM dbo.userPracticeDB WHERE AccountIDX = @ACCOUNT_IDX AND PracticeIDX = @PRACTICE_IDX
|
|
IF(@@ROWCOUNT = 0)
|
|
BEGIN
|
|
SELECT -1;
|
|
RETURN ;
|
|
END
|
|
|
|
BEGIN TRAN
|
|
|
|
UPDATE dbo.userPracticeDB
|
|
SET PracticeCount = @PRACTICE_COUNT
|
|
WHERE AccountIDX = @ACCOUNT_IDX AND PracticeIDX = @PRACTICE_IDX
|
|
|
|
IF (@@ROWCOUNT = 0) or (@@ERROR <> 0)
|
|
BEGIN
|
|
ROLLBACK TRAN
|
|
SELECT -1;
|
|
RETURN;
|
|
END
|
|
|
|
COMMIT TRAN
|
|
|
|
SELECT 1;
|
|
RETURN;
|
|
|
|
GO
|
|
|
|
|