SQL 多筆處理用法

1.多筆更新

UPDATE s
SET s.dt_approve = t.TT
FROM accounting.dbo.fixasset_scrap s INNER JOIN
accounting.dbo.TT t ON
(s.scrap_no = t.apply_no and s.scrap_no='SC06120002')

2.多筆更新
update emp_mstr set emp_photo='\\cnchr\PHOTO\photo\0394866.jpg' where emp_no='0394866'
select 'update emp_mstr set emp_photo="' + 'D:' + '\PHOTO\photo\' + emp_no + '.jpg' + '" where emp_no = ' + '"' + emp_no + '"',
emp_photo
from emp_mstr
where emp_photo not like '%PHOTO\photo\%'
and emp_photo <> ''