Simple temporary table problem

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

ishoni

Don’t do the first sentence: declare @t table(S_DATA int,S_TIME int,S_ID int) try

老庄儿

select can not directly use variables as queries, use dynamic statements

shijie428

A simple SQL common sense, if the table exists, you cannot select into, you must insert into. Since the table variable must be declared before it is used, then you cannot select into.

pupity

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

lvdongfang

declare @t table(S_DATA int, S_TIME int, S_ID int) is useless

2720300

pupityV

郑笑天

pupitypunctuality
Do good things for the people! ! ! ! ! ! ! ! ! ! ! ! ! !

andy__pp

I am also a novice and I have learned one more, so it is correct to sayshijie428.

Learn! ! !