从一个表查询数据插入另一个表 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])