I need to update several columns of several SQL tables based on corresponding entries in one another table (Master Table).
Structure of Master Table
Table Name Column Names
Table_A Table_A_Col_A ,Table_A_Col_B , Table_A_Col_C
Table_B Table_B_Col_D, Table_B_Col_E, Table_B_Col_F
i.e. I have name of the table and all columns which need to be update, also all column will be updated with value 'ZZZZ' where number of Z will be equal to the length of that corresponding column.
I am looking for Dynamic SQL Script that will update the tables based on the entries in the Master table, i.e. let say for e.q. on first iteration, Table_A_Col_A ,Table_A_Col_B , Table_A_Col_C of Table_A will get updated and then for Table_B and so on.