Error Invalid object name 'dbo.fn1'.

Posted by Sanhtech under Sql Server on 6/18/2013 | Points: 10 | Views : 824 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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?

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	Got the ans its select [dbo].fn1(3) Sanhtech, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

how to add title in anchor using jquery (2)Updated
Use Case, Technical/Requirement/SRS Document (1)
LINQ to SQL vs Entity Framework (1)Updated
Dependency injection in MVC and how to acomplish, constructor level interface implement (0)
Difference between select and where in linq (0)
Pperformance tuning in sql other than profiler (1)
Benefit of singleton Design pattern (0)
How to design a project (0)
More ...