@Mark, this actually makes sense, why is this downvoted?
The sample code in Listing 1 demonstrates that you can use the FROM clause combined with a JOIN operation to update specified columns from a second table.
Would you like to answer one of these unanswered questions instead?
Hi All, I've two table (table A, table B ) table B is empty with column names, I need to copy the table a column's data to table B by one- one column. Go" id="ctl00_m_m_i_ctl00_gr_ctl13_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4827099" / Creating a view like this: Create View view_1 as insert column 1 into table_B select Column 1 from Table_A // Add your actions Here insert column 2 into table_B select Column 2 from Table_A // Add your actions Here . Updates are much more expensive than inserts (or deletes) in terms of performance.
However, you have no way of influencing what the last row will be, and on multiprocessor machines where the query might be parallelized, the last row might differ from execution to execution.
Therefore, we recommend that you avoid the 1: M relationship.
When you design relational expressions, you have to decide whether you want a single row to match multiple rows (in a one-to-many—1: M—relationship) or you want many rows to match a single row in the joined table (i.e., you want to update all rows).