存储过程demo

USE [Elefu]
GO
/****** Object:  StoredProcedure [DB_Division].[UP_GetGameInfo]    Script Date: 2017/7/21 星期五 15:35:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:        张倬伟
-- Create date: 2016-08-15
-- Description:    获取玩法信息
-- =============================================
ALTER PROCEDURE [DB_Division].[UP_GetGameInfo]
    @GameEname VARCHAR(10),
    @SellAreaCode VARCHAR(1000)
AS
BEGIN
    IF EXISTS(SELECT 1 FROM DB_Division.DicGame WHERE GameEname=@GameEname AND SellAreaCode=@SellAreaCode)
    BEGIN
        SELECT TOP 1 GameID,GameEname,GameCname,SellAreaCode,GameType 
        FROM DB_Division.DicGame 
        WHERE GameEname=@GameEname AND SellAreaCode=@SellAreaCode
    END
    ELSE
    BEGIN
        SELECT TOP 1 GameID,GameEname,GameCname,SellAreaCode,GameType 
        FROM DB_Division.DicGame 
        WHERE GameEname=@GameEname AND SellAreaCode=10
    END
END