這句話沒update相關條件數據
UPDATE a SET StoreLoc='BB' WHERE DayID IN (@DayID,@DayID1,@DayID2) AND SubString(Lgort,1,1)='W' AND Team IN('IP-xxx','SWxxx')
?
這句話能查到相關條件數據
select * from a??WHERE DayID IN (@DayID,@DayID1,@DayID2) AND SubString(Lgort,1,1)='W' AND Team IN('IP-xxx','SWxxx')
sql存儲過程update無敵BUG
蝴蝶不菲
2018-12-06 16:47:02
