优化3

模糊查询不支持

自动上架

SELECT [MATERIAL_NO]
      ,[UOM_NAME]
      ,[REEL_BARCODE]
      ,[WAREHOUSE]
      ,[LOCATION]
      ,[STATUS]
  FROM [Udit.Mms].[dbo].[mms_reels]
 -- update [Udit.Mms].[dbo].[mms_reels] set [WAREHOUSE]='ASSA',[LOCATION]='ASSA_ALL',[STATUS]='1'
  where [MATERIAL_NO]='APAC_Machine'

不存在的插入

  FROM [Udit.Mms].[dbo].[mms_Stocktaking]
  where DATEDIFF(SECOND, [CreateDate], getdate()) >10 and
  [BillNo] not in(SELECT [BillNo]  FROM [Udit.Mms].[dbo].[mms_bills])