create function sum1 (@num1 int,@num2 int)
returns int
as
begin
declare @sum int
select @sum=@num1+@num2
if(@sum>10)
select '结果大于10'
else
select @sum
return @sum
end
create function sum1 (@num1 int,@num2 int)
returns int
as
begin
declare @sum int
select @sum=@num1+@num2
if(@sum>10)
select '结果大于10'--应该返回int，而这里却是字符串
else
select @sum
return @sum
end
create function sum1 (@num1 int,@num2 int)
returns int
as
begin
declare @sum int
set @sum=@num1+@num2
if(@sum<=10)
return @sum
end
create function sum1 (@num1 int,@num2 int)
returns int
as
begin
declare @sum int
set @sum=@num1+@num2
if(@sum<=10)
begin
return @sum
end
return 0
end
if object_id('dbo.sum1')is not null drop function dbo.sum1
go
create function sum1 (@num1 int,@num2 int)
returns varchar(10)
as
begin
declare @sum int
declare @s nvarchar(20)
select @sum=@num1+@num2
if @sum>10
set @s=N'结果大于10'
else
set @s=@sum
return @s
end
go
select dbo.sum1(10,15)
if object_id('dbo.sum1')is not null drop function dbo.sum1
go
create function sum1 (@num1 int,@num2 int)
returns nvarchar(10)
as
begin
declare @sum int
declare @s nvarchar(20)
select @sum=@num1+@num2
if @sum>10
set @s=N'结果大于10'
else
set @s=@sum
return @s
end
go
select dbo.sum1(10,15)
/*
----------
结果大于10
*/