请帮忙看一下,执行之后怎么没有输出呢? 表变量只在当前会话中有效, exec 中是引用不到exec外定义的表变量的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 declare @prd char(6)declare @sql varchar(1000) declare @tab varchar(100) set @prd='200807'set @tab = 'dbo.kqbrush'+@prd DECLARE @chuqin TABLE([name] [char] (10),[no] [varchar] (10),[bmno] [char] (10),[bmmc] [char] (20)) set @sql='insert into @chuqin select name,no,bmno,bmmc from '+@tab execute (@sql) select * from @chuqin 执行结果是:Server: Msg 137, Level 15, State 2, Line 1Must declare the variable '@chuqin'.(0 row(s) affected)请问还要声明一次吗?如何更改呢? -- 下面这样是可以的(将定义和使用放在同一作用域declare @prd char(6) declare @sql varchar(1000) declare @tab varchar(100) set @prd='200807' set @tab = 'dbo.kqbrush'+@prd set @sql='DECLARE @chuqin TABLE([name] [char] (10),[no] [varchar] (10),[bmno] [char] (10),[bmmc] [char] (20)) insert into '+ @chuqin +' select name,no,bmno,bmmc from '+@tab + ' select * from @chuqin ' execute (@sql) -- 或者临时表declare @prd char(6) declare @sql varchar(1000) declare @tab varchar(100) set @prd='200807' set @tab = 'dbo.kqbrush'+@prd CREATE TABLE #chuqin([name] [char] (10),[no] [varchar] (10),[bmno] [char] (10),[bmmc] [char] (20)) set @sql='insert into #chuqin select name,no,bmno,bmmc from '+@tab execute (@sql) select * from #chuqin DROP TABLE #chuqin sql中当往一个表中添加数据时怎么让一列自动生成如a00000001格式的递增ID 写一个查询某表中某个字段中的值出现n次以上的 存储过程 请问:sql 2000 和 sql 2005 在安装时的实例是什么意思? 如何将数据库1的表A 复制到数据库的表B 求一条 求和语句!!!急 急 急 !!! 性能问题 查询,子查询,很简单的问题 敬请各路高手指教 求一个SQL语句 怎样规定用户的权利? 求一个sql,急 为何此处为空不可以?
declare @sql varchar(1000)
declare @tab varchar(100) set @prd='200807'
set @tab = 'dbo.kqbrush'+@prd DECLARE @chuqin TABLE([name] [char] (10),[no] [varchar] (10),[bmno] [char] (10),[bmmc] [char] (20)) set @sql='insert into @chuqin select name,no,bmno,bmmc from '+@tab
execute (@sql)
select * from @chuqin
执行结果是:
Server: Msg 137, Level 15, State 2, Line 1
Must declare the variable '@chuqin'.(0 row(s) affected)请问还要声明一次吗?如何更改呢?
declare @prd char(6)
declare @sql varchar(1000)
declare @tab varchar(100) set @prd='200807'
set @tab = 'dbo.kqbrush'+@prd
set @sql='
DECLARE @chuqin TABLE([name] [char] (10),[no] [varchar] (10),[bmno] [char] (10),[bmmc] [char] (20))
insert into '+ @chuqin +' select name,no,bmno,bmmc from '+@tab + '
select * from @chuqin
'
execute (@sql)
declare @prd char(6)
declare @sql varchar(1000)
declare @tab varchar(100) set @prd='200807'
set @tab = 'dbo.kqbrush'+@prd CREATE TABLE #chuqin([name] [char] (10),[no] [varchar] (10),[bmno] [char] (10),[bmmc] [char] (20)) set @sql='insert into #chuqin select name,no,bmno,bmmc from '+@tab
execute (@sql)
select * from #chuqin
DROP TABLE #chuqin