Select @FQID=FQ_ID from + @dbName@ + .dbo.st_ytfq where DW_DM=@DWDM 如何实现返回@FQID得值呢

[kyc]

这个语句是在存储过程中执行

@DbName,@DWDM是存储过程的参数

Select @FQID=FQ_ID from + @dbName@ + .dbo.st_ytfq where DW_DM=@DWDM

我需要返回@FQID

[davytao1018]

declare @rid int, @sqls nvarchar(200)
set @sqls='Select @FQID=FQ_ID from '+ @dbName+'.dbo.st_ytfq where DW_DM='''+@DWDM+''''
exec sp_executesql @sqls,N'@FQID int output',@rid output

print @rid
--@rid就是返回查询值的变量

[Well]

CREATE PROCEDURE ProName
@FQID varchar(2000) output,
@dbName varchar(100),
@DWDM varchar(50)
as
set @FQID=''
Select @FQID=FQ_ID from + @dbName + .dbo.st_ytfq where DW_DM=@DWDM
select @FQID
go
然后調用存儲過程時一定要加output
declare @a varchar(200)
declare @b varchar(100)
ProName @a output,@b

[jinjazz]

参考
use northwind
go

declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from orders'
exec sp_executesql @sqls,N'@a int output',@num output
select @num


/*
-----------
830

*/

[Well]

可以定義一個輸出變量output嗎﹗﹗﹗
將安返回出來就行。