58 lines
1.2 KiB
Transact-SQL
58 lines
1.2 KiB
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_PCBangPlayTime_My_RewardList] Script Date: 01/18/2018 12:57:10 ******/
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[game_PCBangPlayTime_My_RewardList]') AND type in (N'P', N'PC'))
|
|
DROP PROCEDURE [dbo].[game_PCBangPlayTime_My_RewardList]
|
|
GO
|
|
|
|
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_PCBangPlayTime_My_RewardList] Script Date: 01/18/2018 12:57:10 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
|
|
--IF OBJECT_ID('dbo.game_PCBangPlayTime_My_RewardList','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.game_PCBangPlayTime_My_RewardList
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.game_PCBangPlayTime_My_RewardList
|
|
-- DBA :
|
|
-- DATE : 2015-06-17
|
|
-- Description : ÈÆ·Ã µ¥ÀÌÅÍ »ý¼º
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[game_PCBangPlayTime_My_RewardList]
|
|
|
|
@ACCOUNT_IDX INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
SELECT PCBangDate
|
|
, AccountIDX
|
|
, PCBangCount
|
|
, PCBangBonusCash
|
|
FROM LosaGame.dbo.userPCBangPregentDB WITH (READUNCOMMITTED)
|
|
WHERE AccountIDX = @ACCOUNT_IDX
|
|
|
|
|
|
GO
|
|
|
|
|