In a database there are two tables which has different columns except for one column that has varbinary(max) column. I want to move the table B varbinary(max) column data into table A varbinary(max) column, in the sense need to update table A. I have found few solutions but they use join or should have relation between the tables like foreign key. Table A has primary key and table B is heap. I tried adding an id column to both as primary key, but table A primary key has relation to many other tables so can't drop primary key from table A. Please need solution to update the column in TableA from TableB with out using join.
You don't have to use a JOIN operation to do this. You can simply: UPDATE TableA SET Column1 = b.Column FROM TableB AS b WHERE TableA.SomeIdentifier = b.Someotheridentifier But, you must have a mechanism for matching one row to the other. You can't be planning to just randomly connect these two tables up, right? There is some data relatnship? Use that in the WHERE clause.