sql - Using subquery in update statement - Stack Overflow

sql - Using subquery in update statement - Stack Overflow

瀏覽:580
日期:2025-11-22
Try this: Update [A] set A.Code = 10, A.Name = 'Test', A.Link = ISNULL((Select Link from [B] where [B].ID = 10),'it was null') from [A] SELECT * FROM ......看更多