create proc p_table2 @a1 varchar(25),@a2 varchar(25)
as
exec('update '+ @a1+' set z5=1 from '+ @a2+' as b where '+@a1+'.z1=b.z1 and '+@a1+'.z2=b.z2 and '+@a1+'.z3=b.z3')
create proc p_updatetable @a1 varchar(25),@a2 varchar(25)
as
exec('update '+ @a1+' set z5=1 from '+ @a2+' as b where '+@a1+'.z1=b.z1 and '+@a1+'.z2=b.z2 and '+@a1+'.z3=b.z3')