Error Invalid object name 'dbo.fn1'.

Posted by Sanhtech under Sql Server on 6/18/2013 | Points: 10 | Views : 848 | Status : [Member] | Replies : 1
I have created function
create function fn1(@a int)
RETURNS int
As
BEGIN
declare @d int
set @d = @a * 2
return @d
END

but its giving error of Invalid object name 'dbo.fn1'.
after running this
select * from dbo.fn1(3)

Whats error?




Responses

Posted by: Sanhtech on: 6/18/2013 [Member] Starter | Points: 25

Up
0
Down
Got the ans

its select [dbo].fn1(3)

Sanhtech, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response