请问我定义一个表变量,如何把结果集写到一个表变量呢如下

wiwiclcl

declare @table1 table (nvarchar(20),nvarchar(20))


select * into @table1 from(select * from.......)

上面的式子不行啊

thanks

我是杀人狂

declare @table1 table (a nvarchar(20),b nvarchar(20))


insert into @table1 select * from(select * from.......)a

michealhenry

declare @mytable table
(
id int,
name varchar(10)
)

insert into @mytable(id,name)
select 1,'张三'

select * from @mytable

--结果
1        张三

fanfan1980

--try

declare @table1 table (col1 nvarchar(20), col2 nvarchar(20))

insert @table1 select col1, col2 from tbName

muyizouzhao

declare @table1 table (col1 nvarchar(20), col2 nvarchar(20))
insert into @table1(col1,col2) select col1, col2 from tbName
或
insert into @table1 select col1, col2 from tbName

写表变量数据最好写列名