USE THNativeWebDBGO IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].WSP_PW_GetRecommendGame') and OBJECTPROPERTY(ID, N'IsProcedure') = 1)DROP PROCEDURE [dbo].WSP_PW_GetRecommendGameGO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ------------------------------------------------------------------------------------------------------ 问题反馈CREATE PROCEDURE WSP_PW_GetRecommendGame@CountINT-- 查询数量WITH ENCRYPTION AS -- 属性设置SET NOCOUNT ON -- 执行逻辑BEGIN SELECT TOP(@Count) * FROM GameRulesInfo WHERE KindID IN (SELECT KindID FROM THPlatformDBLink.THPlatformDB.dbo.GameKindItem WHERE JoinID=2) RETURN 0ENDRETURN 0GO

USE THNativeWebDB
GO
IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[dbo].WSP_PW_GetRecommendGame') and OBJECTPROPERTY(ID, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].WSP_PW_GetRecommendGame
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE WSP_PW_GetRecommendGame
@CountINT-- 查询数量
WITH ENCRYPTION AS
SET NOCOUNT ON
BEGIN
SELECT TOP(@Count) * FROM GameRulesInfo WHERE KindID IN (SELECT KindID FROM THPlatformDBLink.THPlatformDB.dbo.GameKindItem WHERE JoinID=2)
RETURN 0
END
RETURN 0
GO