[MSSQL] Script; copy column data
Good day People,
I dont know if this is the right place but i want to ask some help here.
I wanted to copy table column information from another table column but will match the same name.
Its like restoring only the table column data from old table column data. this is the logic of the script
update tablenew set tablenew.columnnew=tableold.columnold where tablenew.columnew1=tableold.tableold1
i wanted to copy the old information of my column and put it to my new table column because it is the only part of the database that needs restoration.
If im in wrong section please move
Re: [MSSQL] Script; copy column data
Quote:
Originally Posted by
-Jumong-
Good day People,
I dont know if this is the right place but i want to ask some help here.
I wanted to copy table column information from another table column but will match the same name.
Its like restoring only the table column data from old table column data. this is the logic of the script
update tablenew set tablenew.columnnew=tableold.columnold where tablenew.columnew1=tableold.tableold1
i wanted to copy the old information of my column and put it to my new table column because it is the only part of the database that needs restoration.
If im in wrong section please move
have you tried such a query in the query analyzer?
