输出传值问题 DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20)set @min='fid' EXEC(' select '+ @min+' from dbo.fbase ') --查出来的值是0 ,请问怎么把这个值弄到@oldDate select @oldDate 我这个是要写在触发器里面的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20)set @min='fid' EXEC(' select @oldDate = '+ @min+' from dbo.fbase ') select @oldDate EXEC(' select @oldDate = '+ @min+' from dbo.fbase ') 必须声明变量 '@oldDate'。 DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20)DECLARE @sqls nvarchar(4000)set @min='name'set @sqls='select @a='+@min+' from dbo.fbase'EXEC sp_executesql @sqls,N'@a varchar(20) output',@oldDate outputselect @oldDate DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20) OUTPUTset @min='fid' EXEC sp_executesql 'select @oldDate = '+ @min+' from dbo.fbase',@oldDATE output 4楼正确请问如果在触发器里怎么写?set @sqls='select @a='+@min+' from deleted '这样会提示没有Deleted的 那就不能传动态的直接显示指定@min这个值 或者通过分支语句去判断 DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20)DECLARE @sqls nvarchar(4000)SELECT * INTO ##TB FROM DELETEDset @min='name'set @sqls='select @a='+@min+' from ##TB'EXEC sp_executesql @sqls,N'@a varchar(20) output',@oldDate outputselect @oldDate set @min='name'这里目的是什么 @min很多种情况吗 http://topic.csdn.net/u/20110524/16/b08d09ac-034c-4cbb-9b40-b1acc45e7c94.html请转看一楼和八楼 DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20),@sqls nvarchar(1000)set @min='fid'set @sqls='select @oldDate='+ @min+' from a'EXEC sp_executesql @sqls,N'@oldDate varchar(20) output',@oldDate outputselect @oldDate DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20),@sqls nvarchar(1000)set @min='fid'set @sqls='select @oldDate='+ @min+' from dbo.fbase'EXEC sp_executesql @sqls,N'@oldDate varchar(20) output',@oldDate outputselect @oldDate DECLARE @min VARCHAR(20)DECLARE @oldDate VARCHAR(20)set @min='fid' select @oldDate = @min from dbo.fbase print(@oldDate) sql 求解 VC调用存贮过程能否直接用SQL语句 关于Access计算列,在Access表设计页面中在字段SN的默认值栏中填入'abc'+[id],总是出错 关于SQLSERVER数据库的问题 求一SQL语句 想要这个效果怎么实现?求解答 触发器中,inserted表与deleted表,可以通过什么字段实现连结对应。 SQL TEXT类型字段连接的问题 33.6K连接速率下远程数据交换的几种方案 菜鸟求助大神,求救! 求教:创建视图 sql语句时间问题 请进
DECLARE @oldDate VARCHAR(20)
set @min='fid'
EXEC(' select @oldDate = '+ @min+' from dbo.fbase ')
select @oldDate
DECLARE @oldDate VARCHAR(20)
DECLARE @sqls nvarchar(4000)set @min='name'
set @sqls='select @a='+@min+' from dbo.fbase'EXEC sp_executesql @sqls,N'@a varchar(20) output',@oldDate output
select @oldDate
DECLARE @oldDate VARCHAR(20) OUTPUT
set @min='fid'
EXEC sp_executesql 'select @oldDate = '+ @min+' from dbo.fbase',@oldDATE output
set @sqls='select @a='+@min+' from deleted '
这样会提示没有Deleted的
直接显示指定@min这个值 或者通过分支语句去判断
DECLARE @min VARCHAR(20)
DECLARE @oldDate VARCHAR(20)
DECLARE @sqls nvarchar(4000)
SELECT * INTO ##TB FROM DELETED
set @min='name'
set @sqls='select @a='+@min+' from ##TB'EXEC sp_executesql @sqls,N'@a varchar(20) output',@oldDate output
select @oldDate
这里目的是什么 @min很多种情况吗
DECLARE @oldDate VARCHAR(20),@sqls nvarchar(1000)
set @min='fid'set @sqls='select @oldDate='+ @min+' from a'
EXEC sp_executesql @sqls,N'@oldDate varchar(20) output',@oldDate output
select @oldDate
DECLARE @oldDate VARCHAR(20),@sqls nvarchar(1000)
set @min='fid'set @sqls='select @oldDate='+ @min+' from dbo.fbase'
EXEC sp_executesql @sqls,N'@oldDate varchar(20) output',@oldDate output
select @oldDate
DECLARE @oldDate VARCHAR(20)
set @min='fid'
select @oldDate = @min from dbo.fbase
print(@oldDate)