FROM fn_String_To_Table(@LotName,',',1)
SELECT LotPK,LotName INTO #WorkLotPK FROM MMLots WITH(NOLOCK...SourceLotPK只能在这里求
SELECT a.LotPK,a.SourceLotPK into #WorkSourcePK FROM MMLotOperations a WITH(NOLOCK...)类似[先根据外部序列号求解序列号,再照搬第一个判断变量的方式]
SELECT LotPK,LotName INTO #WorkLotPKX FROM MMLots WITH(NOLOCK...,b.LotName AS SourceLotName,NULL FROM #WorkSourcePK2X a JOIN (SELECT LotPK,LotName FROM MMLots WITH(NOLOCK...本文的优化思想很简单,关键点是避免全表扫描 & 注重SQL语句写法 & 索引,另外,如果你查询的表有可能会在查询时段更新,而实际业务需求允许脏读,可加with(nolock)预防查询被更新事物阻塞。