[email protected],@rq得到id,可是好象一直都没有值啊?
存储过程如下:
CREATE PROCEDURE [kqsa2007].[Sp_RunId]
@kqkh char(10),
@rq char(10),
@id char(50) output
AS
select @id=id from totalday where [email protected] and [email protected];
------解决方案--------------------
- SQL code
use kqsa2007declare @id char(50)exec sp_runid 'a','b',@id outputselect @id
------解决方案--------------------
- SQL code
CREATE PROCEDURE [kqsa2007].[Sp_RunId] @kqkh char(10), @rq char(10), @id char(50) output AS select @id=id from totalday where [email protected] and [email protected]; return @id---加上这个
------解决方案--------------------
CREATE PROCEDURE [kqsa2007].[Sp_RunId]
@kqkh char(10),
@rq char(10),
@id char(50) output
AS
select @id=id from totalday where [email protected] and [email protected]
return @id;
逗号放到最后