declare @table table([name] varchar(50))
insert into @table([name]) values('x1')
insert into @table([name]) values('x2')
insert into @table([name]) values('x3')declare @table1 table([name] varchar(50))insert into @table1
select [name] from @table where [name]='x1'select * from @table1
insert into @table([name]) values('x1')
insert into @table([name]) values('x2')
insert into @table([name]) values('x3')declare @table1 table([name] varchar(50))insert into @table1
select [name] from @table where [name]='x1'select * from @table1
insert into @table([name]) values('x1')
insert into @table([name]) values('x2')
insert into @table([name]) values('x3')declare @table1 table([name] varchar(50))insert into @table1
select [name] from @table where [name]='x1'select * from @table1