sql 标量值函数

--定义标量值函数
if exists(select * from sysobjects where name='calc')
 drop function calc
go

create function calc(@num1 int,@num2 int)
returns int 
as
begin
 declare @result int
 set @result=@num1+@num2
 return @result
end
 
--调用标量值函数
declare @result int
set @result=dbo.calc(2,2)
print @result