棘手问题 SELECT @code=@receiver_code from table2就这样写不行吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用动态语句类似下:declar @receiver_code varchar(10),@code varchar(35) select @receiver_code=isnull(receiver_code,'') from insertedselect @receiver_code = 'select '+@receiver_code +' from table2'exec(@receiver_code) 根据你的意思写的:declare @code varchar(100) --字段值declare @receiver_code varchar(10) --字段名declare @sql nvarchar(1000)set @receiver_code = 'lname' set @sql = 'select @code = '+@receiver_code+ 'from pubs.dbo.employee'execute sp_executesql @sql, N'@code varchar(100) output', @code=@code outputselect @code Chiff(~o~) :不行呀!编译不出错,但触发时,认识不到@receiver_code,总报”pubs附近有语法错误“??? 同个表,有数据能select出来,有些数据select不出来 无法启动sql server服务 求一SQL语句 数据库数据偶然丢失的问题 大家一起来呀!! 过程中,表名做为输入变量,没搞定.SQL语句不动,就传入不同的表名. sql2008 很奇怪的一个sql问题 有没人用VFP做过C/S结构的软件?请谈谈心得? 开始学存储过程,例子运行不了,请帮我看看,急! 触发器问题。在线等! 简单的问题,快看看吧,关于SQL语句的!!!! 请看一下Select Count(*) From TableName与Select ID From TableName在性能上有什么差别
declar @receiver_code varchar(10),@code varchar(35)
select @receiver_code=isnull(receiver_code,'') from inserted
select @receiver_code = 'select '+@receiver_code +' from table2'exec(@receiver_code)
declare @receiver_code varchar(10) --字段名
declare @sql nvarchar(1000)set @receiver_code = 'lname'
set @sql = 'select @code = '+@receiver_code+
'from pubs.dbo.employee'execute sp_executesql
@sql,
N'@code varchar(100) output',
@code=@code outputselect @code
不行呀!编译不出错,但触发时,认识不到@receiver_code,总报”pubs附近有语法错误“???