declare @ProductVarious varchar(4000)
declare @dd varchar(4000)
declare @sql varchar(4000)
DECLARE @t TABLE(ID varchar(20) )
declare @c int
BEGIN
set @sql='select id from @t'
insert into @t SELECT PROD_ID FROM tableA
insert into tableB exec(@sql)
END
最後一步出現錯誤:Must declare the table variable "@t".
求解答
declare @dd varchar(4000)
declare @sql varchar(4000)
DECLARE @t TABLE(ID varchar(20) )
declare @c int
BEGIN
set @sql='select id from @t'
insert into @t SELECT PROD_ID FROM tableA
insert into tableB exec(@sql)
END
最後一步出現錯誤:Must declare the table variable "@t".
求解答
declare @dd varchar(4000)
declare @sql varchar(4000)
DECLARE @t TABLE(ID varchar(20) )
declare @c int
BEGIN
--set @sql='select id from @t'
insert into @t SELECT PROD_ID FROM tableA
insert into tableB SELECT ID FROM @T
END
改为 CREATE TABLE #t(ID VARCHAR(20))
后面将对@t的操作改为操作#t
insert into #t values (1,'kaishi')
declare @name varchar(20)
declare @sql varchar(2000)
set @name='kai' set @sql='select id from #t where strname like ''%'+@name+'%'''
print @sql
insert into tableB exec(@sql)