我不会这个问题?哪位 帮我解决?

Question

if exists(select * from dbo.sysobjects where id=object_id(N'dbo.MultipleThreeValue') 
and objectproperty(id,N'isprocedure')=1)
drop procedure dbo.MultipleThreeValue
go
create procedure MultipleThreeValue
@number1 int,
@number2 int,
@number3 int
as
return @number1*@number2*@number3
declare @CountResult int
execute @CountResult=MultipleThreeValue 19,34,59
select '19乘34乘59=',@CountResult
错误信息是:
无法在 sysdepends 中添加当前存储过程所对应的行，因为缺少该存储过程所依赖的对象 'MultipleThreeValue'。仍将创建该存储过程。
我要怎么样解决这个问题?

Answer 1

create proc MultipleThreeValue
@number1 int,
@number2 int,
@number3 int
as
return @number1*@number2*@number3
godeclare @CountResult int
execute @CountResult=MultipleThreeValue 19,34,59
select '19乘34乘59=',@CountResult
少go!

Answer 2

if exists(select * from dbo.sysobjects where id=object_id(N'dbo.MultipleThreeValue') 
and objectproperty(id,N'isprocedure')=1)
drop procedure dbo.MultipleThreeValue
gocreate procedure MultipleThreeValue
 @number1 int,
 @number2 int,
 @number3 int,
 @Countresult int OUTPUT
as
set @Countresult=@number1*@number2*@number3
godeclare @CountResult int
execute MultipleThreeValue 19,34,59,@CountResult OUTPUT
select '19乘34乘59='+cast(@CountResult as varchar) as 结果

Answer 3

if exists(select * from dbo.sysobjects where id=object_id(N'dbo.MultipleThreeValue') 
and objectproperty(id,N'isprocedure')=1)
drop procedure dbo.MultipleThreeValue
go
create procedure MultipleThreeValue
@number1 int,
@number2 int,
@number3 int
as
return @number1*@number2*@number3go declare @CountResult int
execute @CountResult=MultipleThreeValue 19,34,59
print @CountResultselect [19乘34乘59]=@CountResult