May I define a table variable, how to write the result set to a table variable is as follows

wiwiclcl

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


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

The formula above doesn't work

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, 'Zhang San'

select * from @mytable

--result
1 sheet three

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
or
insert into @ table1 select col1, col2 from tbName

Writing table variable data is best written column names