SQL Server的update和join联合使用 2023-7-13 15:46 | 455 | 0 | 编程 UPDATE t1 SET t1.col2=t2.col2, t1.col3=t2.col3 FROM t1 [INNER JOIN|LEFT JOIN] t2 ON t1.col1=t2.col1 WHERE .......SQL sql
SQL Server的select和insert联合使用 2023-7-13 15:40 | 128 | 0 | 编程 insert into tableName (col1,col2,col3) select col1,col2,col3 from .......SQL sql