八达网

标题: SQL2000的存储过程如何转换成SQL2005的存储过程? [打印本页]

作者: 装B不如装锅 时间: 2007-11-3 21:03
标题: SQL2000的存储过程如何转换成SQL2005的存储过程?
五十水晶酬谢.

作者: 装B不如装锅 时间: 2007-11-3 21:06
标题: 比如这个存储过程.
CREATE PROCEDURE [insert_ydlife]

   (@LuXian    [nvarchar](50),

      @XiBie       [nvarchar](50),

      @CheCi    [nvarchar](50),

      @FaCheRiQi    [datetime],

      @LianXiRen       [nvarchar](50),

      @DianHua [nvarchar](50),

      @CaiJiShiJian    [datetime],

      @urlFrom [nvarchar](100),

      @retValue    int OUTPUT)

AS

IF EXISTS (SELECT * FROM ydlife

      WHERE  CheCi = @CheCi AND FaCheRiQi = @FaCheRiQi  AND DianHua = @DianHua)

BEGIN

set @retValue = -1

END

ELSE

BEGIN

INSERT INTO ydlife

      ( [LuXian],

      [XiBie],

      [CheCi],

      [FaCheRiQi],

      [LianXiRen],

      [DianHua],

      [CaiJiShiJian],

      [urlFrom]

      )

VALUES

      ( @LuXian,

      @XiBie,

      @CheCi,

      @FaCheRiQi,

      @LianXiRen,

      @DianHua,

      @CaiJiShiJian,

      @urlFrom

      )

set @retValue = 0

END

GO

欢迎光临八达网 (https://www.8-da.com/)