sqlserver update join 

update a set a.UserAgent  = b.UserAgent
from InfoVisitDetails a
inner join InfoVisitDetails b on a.IP = b.IP where a.VisitUrl like 'https://%' and a.IP=a.UserAgent

 

posted @ 2023-02-07 09:56  极客船长  阅读(59)  评论(0)  编辑  收藏  举报