Inline table value function : invalid object name

Question

1.00/5 (2 votes)

See more:

When I call an inline table value function I get this error:

"Invalid object name Reservations.ReservationDetails"

What I have tried:

This is my Inline Table Value Function:

SQL

DECLARE @IDMovies INT = Movies.IDMovies
CREATE FUNCTION [dbo].Reservations.ReservationDetails (@IDMovies INT)
RETURNS TABLE  
AS
RETURN  
         SELECT *
     FROM Movies m
     INNER JOIN Reservations r ON b.IDMovies = r.IDMovies

Posted 6-Nov-20 3:36am

xhon

Updated 7-Nov-20 5:12am

Herman<T>.Instance

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2020-11-06T03:51:00

Solution 1

Your function name cannot contain a . unless you escape it.
Database Identifiers - SQL Server | Microsoft Docs[^]

Give it a simpler name:

SQL

CREATE FUNCTION dbo.ReservationDetails (@IDMovies INT)

Or create it in a separate schema:

SQL

CREATE FUNCTION Reservations.ReservationDetails (@IDMovies INT)

If you really want to shoot yourself in the foot, escape the function name. You will also need to escape it every time you call it.

SQL

-- Don't do this!
CREATE FUNCTION [dbo].[Reservations.ReservationDetails] (@IDMovies INT)

Posted 6-Nov-20 3:51am

Richard Deeming

Comments

xhon 6-Nov-20 10:40am

I got this other error message:
"Column names in each view or function must be unique. Column name 'IDMovies' in view or function 'ReservationDetails' is specified more than once."

Richard Deeming 6-Nov-20 10:43am

Don't use SELECT * FROM; specify the column list explicitly, and make sure you don't have any duplicate column names.

For example, both tables in your JOIN have a column called IDMovies.

xhon 6-Nov-20 10:51am

OK thanks, I'm gonna drop the table which contains the foreign key and create it again by naming the referring column differently...Or there is a way to avoid dropping the table? Can I use a variable for that column name inside the function maybe?

Richard Deeming 6-Nov-20 10:52am

You don't need to drop the table. Just specify an explicit list of columns in your SELECT statement.