Simple temporary table problem, but confused

pqllll

I use:
declare @t table (S_DATA int, S_TIME int, S_ID int)
select * into @t from text_one

instead:
insert @t
select 3, 12, null union all
select 2, 13, null union all
select 2, 14, null union all

Tip: There is an error near "@t", please solve it for me ~ Thank you

czarsky

The number of columns is different, brother

prajna

Use insert into...select for existing tables.

fanfan1980

--Less the list

hiqwolfzzh

. . . .

fanfan1980

--wrong

declare @t table(S_DATA int,S_TIME int,S_ID int)
insert @t select * from text_one

fanfan1980

declare @t table(S_DATA int,S_TIME int,S_ID int)
insert @t select * from text_one
- Is the text_one table three columns?