declare @tab1 table (num int)
declare @tab2 table (num int)
insert into @tab1 values(5)
insert into @tab2 values(5)
insert into @tab2 values(6)
select * from @tab1 inner join @tab2 on @[email protected]
为什么会出现
'必须声明变量 '@tab1'。'
这个错误
declare @tab2 table (num int)
insert into @tab1 values(5)
insert into @tab2 values(5)
insert into @tab2 values(6)
select * from @tab1 inner join @tab2 on @[email protected]
为什么会出现
'必须声明变量 '@tab1'。'
这个错误
declare @tab2 table (num int)
insert into @tab1 values(5)
insert into @tab2 values(5)
insert into @tab2 values(6)
exec('select * from '+@tab1+' inner join '+@tab2+' on '+@tab1+'.num='+@tab2+'.num'
declare @tab2 table (num int)
insert into @tab1 values(5)
insert into @tab2 values(5)
insert into @tab2 values(6)
select * from @tab1 a inner join @tab2 b on a.num=b.num
declare @tab1 table (num1 int)
declare @tab2 table (num2 int)
insert into @tab1 values(5)
insert into @tab2 values(5)
insert into @tab2 values(6)
select * from @tab1 inner join @tab2 on num1=num2