use dbName;
declare @myTable Table
{
id int,
uName nvarchar(10)
};
insert into myTable
select uId,uName from uInfo where ...;
select * from @myTable;
use dbName;
declare @myTable Table
{
id int,
uName nvarchar(10)
};
insert into myTable
select uId,uName from uInfo where ...;
select * from @myTable;
转载于:https://www.cnblogs.com/jsping/archive/2013/01/10/2855627.html