SQL SERVER how to update a few columns in a table data into another column to the table-CodePudding

Home > database > SQL SERVER how to update a few columns in a table data into another column to the table

SQL SERVER how to update a few columns in a table data into another column to the table

Time：03-04

The UPDATE [ShuCheng real estate]. [dbo]. [ZDJBXX]
The SET ZDXZ=CONCAT ([ZDSZB], [ZDSZX], [ZDSZN], [ZDSZD])
Prompt ZDXZ invalid column name

CodePudding user response:

This field is in ZDJBXX just add the list?

Open the query window closed to try?