with as 的用法解决办法

with as 的用法

SQL code

with  a as (   select col1,col2 from table1)update table2 set col3 = 1 where a.col1 = table2.col1update table3 set col4 = 1 where a.col2 = table3.col2

SQL code

select col1,col2 into #a from table1update table2 set col3 = 1 from table2 inner join #a a on  a.col1 = table2.col1update table3 set col4 = 1 from table3 inner join #a a on where a.col2 = table3.col2