从一个表查询数据插入另一个表

insert into Favorite (title,url,className,userid,time) (select 'test title','http://www.3dxm.com','testclass', ID,getdate() from [user])
insert into Favorite (userid) (select  ID from [user])
原文地址:https://www.cnblogs.com/lovebanyi/p/540969.html