日期:2014-05-18 浏览次数:20480 次
use kqsa2007 declare @id char(50) exec sp_runid 'a','b',@id output select @id
------解决方案--------------------
CREATE PROCEDURE [kqsa2007].[Sp_RunId] @kqkh char(10), @rq char(10), @id char(50) output AS select @id=id from totalday where kqkh=@kqkh and rq=@rq; return @id---加上这个
------解决方案--------------------
CREATE PROCEDURE [kqsa2007].[Sp_RunId]
@kqkh char(10),
@rq char(10),
@id char(50) output
AS
select @id=id from totalday where kqkh=@kqkh and rq=@rq
return @id;
逗号放到最后