SQL 根据一个表的ID去初始化另一个表的值
insert into [Table1](ColumnA,Id,CreatedOn,CreatedBy) select 'Monthly', r.Id,GETDATE(),'System' from Table2 as r
本文来自博客园,转载请注明原文链接:https://www.cnblogs.com/keeplearningandsharing/p/17358310.html
insert into [Table1](ColumnA,Id,CreatedOn,CreatedBy) select 'Monthly', r.Id,GETDATE(),'System' from Table2 as r
本文来自博客园,转载请注明原文链接:https://www.cnblogs.com/keeplearningandsharing/p/17358310.html