insert into .....select......

use dbName;

declare @myTable Table

{

　　id int,

　　uName nvarchar(10)

};

insert into myTable

　　select uId,uName from uInfo where ...;

 

 

select * from @myTable;