DECLARE @RC int DECLARE @Line varchar(30) DECLARE @Station varchar(30) DECLARE @TestDate date DECLARE @TestHour int DECLARE @TestTime datetime DECLARE @SN varchar(30) DECLARE @DSN varchar(30) DECLARE @ODF varchar(30) DECLARE @Model varchar(30) DECLARE @Dimension varchar(30) DECLARE @LastSN int DECLARE @Result int DECLARE @ErrMsg varchar(300) DECLARE @Remark varchar(100) -- TODO: 在此处设置参数值。 SET @Line = 'Test' SET @Station = 'DataBurning' SET @TestDate = '2021-12-02' SET @TestHour = 10 SET @TestTime = '2021-12-02 12:12:03' SET @SN = 'DGG75096992112000808' SET @DSN = '' SET @ODF = 'DGG7509699' SET @Model = '55D2010' SET @Dimension = '55' SET @LastSN = 1 -- 是否连续抄写: 0表示非连续抄写,1表示连续抄写; SET @Result = 1 -- 抄写结果:0表示抄写失败, 1表示抄写成功; SET @ErrMsg = '' SET @Remark = '测试数据' EXECUTE @RC = [MES].[dbo].[DealAMResult] @Line,@Station,@TestDate,@TestHour,@TestTime,@SN,@DSN,@ODF,@Model,@Dimension,@LastSN,@Result,@ErrMsg,@Remark SELECT * FROM AMResult WHERE Line=@Line AND Station=@Station AND SN=@SN --DELETE FROM AMResult WHERE Line=@Line AND Station=@Station AND SN=@SN