Why is function call returning 'Invalid object name'?

Question

It should be something simple, but I can't seem to see it.

Why is this SELECT statement returning Invalid object name 'dbo.ufn_SalesByStore'?

CREATE FUNCTION dbo.ufn_SalesByStore (@storeid int)

RETURNS INT

AS

BEGIN

RETURN (20)

END

GO

--SELECT Call returning 'Invalid object name 'dbo.ufn_SalesByStore'

SELECT * FROM dbo.ufn_SalesByStore (602);

Thanks.

Answer 1

Try:

SELECT dbo.ufn_SalesByStore (602);

---

Regards,

Asim Bagwan

Kindly mark the replies as Answers if they help!

Answer 2

Hello,

You should use as

SELECT dbo.ufn_SalesByStore (602);

 

Your function is a scalar function.

If it was a table valued function, then you can use FROM keyword to read returned data from function

 

---

SQL Server, SQL Server 2012 Denali and T-SQL Tutorials

Answer 3

Because you created a Scalar Function, not a Table-Valued Function.

Answer 4

Hi,

This is a scalar funtion.so we should use the return value in side select statement.you are trying to use the function in place of a table,that is why it is throwing error.

Please refer to the link below on Executing User-Defined Functions 

http://msdn.microsoft.com/en-us/library/ms175562.aspx

---

Vinay Valeti| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer