مطالب مرتبط با «update a column from a select statement» در back soft | نویسنده: استخدام کار
Updating a culumn from a select statement
Vote count: 1 I'm trying to add a new column in my family table called Full Address; It's basically combining values from other columns and generating the Full Address. I wrote this query but it doesn't seem to be working. Alos, I would appreciate it if there's a better way to generate my desired value, Full Address. update Family set FullAddress = select StreetAddress+', '+City+', '+State+', '+ZipCode AS Address from Family Thanks asked 1 min agosam 1 Answer Vote count: 0 Presumably, you just want this: UPDATE Family SET FullAddress = StreetAddress + ', ' + City + ', ' + State + ', ' + ZipCode; edited 4 secs ago answered 54 secs agoGordon Linoff Let's block ads! بخوانید...
ادامه مطلب
