CREATE PROCEDURE reWriteseoutstockentry_ERIC @DingDanHao nvarchar(50) AS begin declare @sqlStr nvarchar(2000) set @DingDanHao='seout000072' --print ''''+@DingDanHao+'''' set @sqlStr=' update T set T.FQTY=C.FQTY, T.F_ONEEDQTY=C.FQTY1, T.FNOTE=C.FTEXT15, T.F_0030=C.FQTY2, T.FENTRYSELFS0245=C.FQTY3, T.F_0500=C.FQTY4, T.F_1000=C.FQTY5, T.F_1430=C.FQTY6, T.FENTRYSELFS0247=C.FQTY7, T.F_1630=C.FQTY8, T.FENTRYSELFS0248=C.FQTY9, T.FENTRYSELFS0246=C.FQTY10, T.FENTRYSELFS0249=C.FQTY11, T.F_2230=C.FQTY12, T.FENTRYSELFS0250=C.FQTY13, T.FENTRYSELFS0251=C.FQTY14 FROM SEOUTSTOCKENTRY as t join t_BOS200000016entry2 C ON C.FENTRYID_SRC=T.FENTRYID AND C.FID_SRC=T.FINTERID AND C.FBILLNO_SRC='+'''' +@DingDanHao+'''' print @sqlStr EXEC sp_executesql @sqlStr if @@error<>0 raiserror ('反向不成功,请联系IT!',16,1) end GO