Cannot find either column dbo or the user-defined function or aggregate or the name is ambiguous – Microsoft SQL
26 January 2011
8,345 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










Leave your response!