请帮忙看一下,执行之后怎么没有输出呢? 表变量只在当前会话中有效, 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 SQL SERVER 收缩数据库的命令如何写 数据在硬盘中是怎么存储的? 表2的最大日期字段更新表1如何写,请帮手,在线等,TKS! 我想通过储存过程取值,请问如何取?注意哦:表名是变量,字段名是ntext类型,有难度! 高手快来抢分~~来看看我的SQL Server为什么总是安装失败? 请教:使用SQL语句创建表的命令如何写 使用like查询时的问题 SQL变态笔试题(续。。。)求解。。。高手来!~~ 不用BCP,用存储过程能实现对某几张表的数据进行备份和恢复吗? 求一个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