[导入]存储过程片段4

    if exists ( select 1 from Spe_IReportExp WHERE IReportNO = @IReportNO)
    begin
    UPDATE Spe_IReportExp
    SET
    Site = @Site ,
    Temperature = @Temperature ,
    Humidity = @Humidity ,
    Limit = @Limit ,
    TCreator = @TCreator 
    WHERE IReportNO = @IReportNO
    end

    else
    begin
    insert into Spe_IReportExp
    values
          (
            @IReportNO ,
            @Site ,
            @Temperature ,
            @Humidity ,
            @Limit ,
            @TCreator
          )
     end

文章来源:http://blog.163.com/kwanchan@yeah/blog/static/855386142008620823862