54 lines
1.3 KiB
Transact-SQL
54 lines
1.3 KiB
Transact-SQL
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_practice_get_list] Script Date: 11/18/2017 17:09:36 ******/
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[game_practice_get_list]') AND type in (N'P', N'PC'))
|
|
DROP PROCEDURE [dbo].[game_practice_get_list]
|
|
GO
|
|
|
|
USE [LosaGame]
|
|
GO
|
|
|
|
/****** Object: StoredProcedure [dbo].[game_practice_get_list] Script Date: 11/18/2017 17:09:36 ******/
|
|
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_get_list]
|
|
|
|
@topn INT,
|
|
@ACCOUNT_IDX INT,
|
|
@PRACTICE_IDX INT
|
|
|
|
AS
|
|
|
|
SET NOCOUNT ON;
|
|
SET LOCK_TIMEOUT 10000;
|
|
|
|
SELECT TOP (@topn) practiceIDX, UPD.AccountIDX, UMD.NickName, PracticeTime, UpdateDate
|
|
FROM dbo.userPracticeDB AS UPD WITH (READUNCOMMITTED)
|
|
JOIN dbo.userMemberDB AS UMD on UPD.AccountIDX = UMD.accountIDX
|
|
WHERE UPD.AccountIDX <= @ACCOUNT_IDX AND UMD.limitDate < GETDATE()
|
|
ORDER by UPD.AccountIDX DESC
|
|
|
|
|
|
GO
|