forked from LosaDev/ls-2019-source
57 lines
1.3 KiB
Transact-SQL
57 lines
1.3 KiB
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_PCBangPlayTime_PCBangList] Script Date: 01/23/2018 16:51:50 ******/
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[game_PCBangPlayTime_PCBangList]') AND type in (N'P', N'PC'))
|
|
DROP PROCEDURE [dbo].[game_PCBangPlayTime_PCBangList]
|
|
GO
|
|
|
|
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_PCBangPlayTime_PCBangList] Script Date: 01/23/2018 16:51:50 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
|
|
--IF OBJECT_ID('dbo.game_PCBangPlayTime_PCBangList','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.game_PCBangPlayTime_PCBangList
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject dbo.game_PCBangPlayTime_PCBangList
|
|
-- DBA
|
|
-- DATE 2014-03-03
|
|
-- Description PC¹æÇ÷¹ÀÌŸÀÓ¸®½ºÆ®
|
|
-- =============================================
|
|
|
|
CREATE PROCEDURE [dbo].[game_PCBangPlayTime_PCBangList]
|
|
|
|
@PCBangIDX INT,
|
|
@SearchDate NVARCHAR(16)
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
DECLARE @Date NVARCHAR(10)
|
|
SET @Date = replace(@SearchDate, '-', '')
|
|
|
|
SELECT PCBangDate
|
|
,PCBangIndex
|
|
,AccountIDX
|
|
,PCBangPlayTime
|
|
FROM LosaGame.dbo.userPCBangPlayTimeDB WITH (READUNCOMMITTED)
|
|
WHERE PCBangIndex = @PCBangIDX AND PCBangDate = @Date AND PCBangPlayTime >= 60
|
|
|
|
GO
|
|
|
|
|