CREATE PROCEDURE manage3 @kh char(8)
ASDECLARE @count int
SELECT @count=COUNT(*) FROM 订购单
WHERE 订购单.客户号=@kh
RETURN @countDECLARE @count intEXECUTE @count= manage3 'KH3'
提示消息 201,级别 16,状态 4,过程 manage3,第 0 行
过程或函数 'manage3' 需要参数 '@kh',但未提供该参数。这到底是个什么问题??
ASDECLARE @count int
SELECT @count=COUNT(*) FROM 订购单
WHERE 订购单.客户号=@kh
RETURN @countDECLARE @count intEXECUTE @count= manage3 'KH3'
提示消息 201,级别 16,状态 4,过程 manage3,第 0 行
过程或函数 'manage3' 需要参数 '@kh',但未提供该参数。这到底是个什么问题??
定义了2次CREATE PROCEDURE manage3 @kh char(8)
ASDECLARE @count int
SELECT @count=COUNT(*) FROM 订购单
WHERE 订购单.客户号=@kh
RETURN @count
EXECUTE @count= manage3 'KH3'
@count int output
AS--DECLARE @count int
SELECT @count=COUNT(*) FROM 订购单
WHERE 订购单.客户号=@kh
RETURN @countDECLARE @count intEXECUTE manage3 'KH3',@count output
select @count
@count int output
AS--DECLARE @count int
SELECT @count=COUNT(*) FROM 订购单
WHERE 订购单.客户号=@kh
RETURN @countDECLARE @rt intEXECUTE manage3 'KH3',@rt output
select @rt
AS
BEGIN
Declare @int int
select @int=ftext from dbo.订购单 Where ftext=@s
return @int
END
GO-----测试没问题!不识别汉字名字表