62,074
社区成员
发帖
与我相关
我的任务
分享如何获得输出类型的参数
有一存储过程
CREATE proc p_qry
@tbname sysname, --要查的表名
@BAB0000 int,
@re nvarchar(4000) out
as
set nocount on
declare @s nvarchar(4000)
set @s=''
select @s=@s+'+case when ['+name+']=2 then '','+name+''' else '''' end'
from syscolumns where id=object_id(@tbname) and name <>'TS' and len(name) <=13
select @s='select @s='+stuff(@s,1,1,'')+' from ['+@tbname+'] where BAB0000=@BAB0000 set @s=stuff(@s,1,1,'''')'
exec sp_executesql @s,N'@s nvarchar(4000) out,@BAB0000 int',@re out,@BAB0000
GO
如何用语句调用存储过程 然后得到 @re nvarchar(4000) out
CREATE proc p_qry
@tbname sysname, --要查的表名
@BAB0000 int,
@re nvarchar(4000) out
as
set nocount on
declare @s nvarchar(4000)
set @s=''
select @s=@s+'+case when ['+name+']=2 then '','+name+''' else '''' end'
from syscolumns where id=object_id(@tbname) and name <>'TS' and len(name) <=13
select @s='select @s='+stuff(@s,1,1,'')+' from ['+@tbname+'] where BAB0000=@BAB0000 set @s=stuff(@s,1,1,'''')'
exec sp_executesql @s,N'@s nvarchar(4000) out,@BAB0000 int',@re out,@BAB0000
GO
如何用语句调用存储过程 然后得到 @re nvarchar(4000) out
...全文
请发表友善的回复…
发表回复
learner01 2004-12-31
- 打赏
- 举报
帮顶！
xxwnet 2004-12-30
- 打赏
- 举报
UP
sunyou 2004-12-30
- 打赏
- 举报
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.2052/vbcon/html/vbtskSettingGettingDataCommandParameters.htm
systemspy 2004-12-30
- 打赏
- 举报
SqlParameter outParam = new SqlParameter(("@re",SqlDbType.Int,4));
outParam.Direction=ParameterDirection.Output ;
//执行
cmd.ExecuteNonQuery();
//得到返回值
outParam.Value
outParam.Direction=ParameterDirection.Output ;
//执行
cmd.ExecuteNonQuery();
//得到返回值
outParam.Value
goody9807 2004-12-30
- 打赏
- 举报
谢谢 能具体说说吗
sunyou 2004-12-30
- 打赏
- 举报
使用带OleDbParameter或SqlParameter的执行SQL方式调用这个存储过程，调用后访问该参数
