SQL错误function

[biaozon]

create function ATB (@a int,@b int)
return int
as
begin
declare @C int
set @C=@a+@b

return @c
end



create proc aa
as
declare @ccc int
set @ccc=ATB(1,2)
select @ccc



exec aa




错误：
Server: Msg 195, Level 15, State 10, Procedure aa, Line 4
'ATB' is not a recognized function name.

[华夏小卒]

set @ccc=dbo.ATB(1,2)

[飘零一叶]

create function ATB (@a int,@b int)
returns int
as
begin
declare @C int
set @C=@a+@b

return @c
end

[飘零一叶]

[Quote=引用 1 楼 js_szy 的回复:]
set @ccc=dbo.ATB(1,2)
[/Quote]
调用的时候加上dbo.ATB

[biaozon]

谢谢你了。飘零一叶
为什么要加dbo呢

[华夏小卒]

他属于架构dbo ，如同vs里的命名空间