Home » Programming / Coding

Cannot find either column dbo or the user-defined function or aggregate or the name is ambiguous – Microsoft SQL

26 January 2011 11,426 views No Comment

You might get into this error when try to select from a table valued function in Microsoft SQL.

Lets say you have a table-valued function named Test.
If you call the function like this
Select dbo.test(param if any)
Then you will be getting the error “Cannot find either column dbo or the user-defined function or aggregate or the name is ambiguous”

The reason of that error is you are missing the column name(s) in the select.

Correct syntax would be something like this:
Select * from dbo.test(param if any)
____________
From Webcosmo Webmaster Forum http://www.webcosmoforums.com/databases/25926-cannot-find-either-column-dbo-user-defined-function-aggregate-name-ambiguous-microsoft-sql.html

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.