是不是這個意思?create table test ( pk_id varchar(20) ) insert into test select '290' Union All select '291'Declare @pk_id varchar(20) Select @pk_id = pk_id From test Where pk_id = '291' Select @pk_id GO Drop Table test --Result /* 291 */
不能用表变量实现select into 用insert...select declare @tb table ( ID int identity, name varchar(20) ) insert @tb(name) select 'AAA'
select * from @tb
不能(游标才用fetch ...into) 如果是单个值可以 select @a=cola from tablea 如果是数据集可以表变量 create table test(pk_id varchar(20)) insert into test select '290' insert into test select '290' insert into test select '290' insert into test select '290' insert into test select '290' insert into test select '290' declare @a table(a int) insert @a select * from test select * from @a
(
pk_id varchar(20)
)
insert into test select '290'
Union All select '291'Declare @pk_id varchar(20)
Select @pk_id = pk_id From test Where pk_id = '291'
Select @pk_id
GO
Drop Table test
--Result
/*
291
*/
用insert...select
declare @tb table
(
ID int identity,
name varchar(20)
)
insert @tb(name) select 'AAA'
select * from @tb
如果是单个值可以 select @a=cola from tablea
如果是数据集可以表变量
create table test(pk_id varchar(20))
insert into test select '290'
insert into test select '290'
insert into test select '290'
insert into test select '290'
insert into test select '290'
insert into test select '290'
declare @a table(a int)
insert @a select * from test
select * from @a