47 lines
1.1 KiB
Transact-SQL
47 lines
1.1 KiB
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_practice_BlockList] Script Date: 01/11/2018 11:59:29 ******/
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[game_practice_BlockList]') AND type in (N'P', N'PC'))
|
|
DROP PROCEDURE [dbo].[game_practice_BlockList]
|
|
GO
|
|
|
|
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_practice_BlockList] Script Date: 01/11/2018 11:59:29 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
|
|
|
|
--IF OBJECT_ID('dbo.game_practice_BlockList','P') IS NOT NULL
|
|
--
|
|
-- DROP PROC dbo.game_practice_BlockList
|
|
--
|
|
--GO
|
|
|
|
-- =============================================
|
|
-- Subject : dbo.game_practice_BlockList
|
|
-- DBA :
|
|
-- DATE : 2015-06-17
|
|
-- Description : ÈÆ·Ã µ¥ÀÌÅÍ »ý¼º
|
|
-- =============================================
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[game_practice_BlockList]
|
|
@KickID varchar(20)
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
SELECT accountIDX FROM LosaGame.dbo.userMemberDB WHERE limitType = 100 AND limitDate > Getdate() - 3 AND userID = @KickID
|
|
|
|
GO
|
|
|
|
|