大家帮我看看,这个为什么会出错误呢~
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'ComputeJX' AND type = 'P')
DROP PROCEDURE ComputeJX
GO
CREATE PROCEDURE ComputeJX
@OutResult Numeric(14,2) Output
AS
Begin
Declare @TheStr Varchar(1000)
Set @TheStr = 'Select @TheResult = 8*7*5 '
Exec sp_executesql @TheStr,'@TheResult Numeric(14,2) output',@TheResult = @OutResult output
End
Declare
@OutResult1 Numeric(14,2)
Exec ComputeJX @OutResult1 output