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/archive/2006/10/26/540969.html