Results 1 to 1 of 1
-
01-26-2011, 01:24 PM #1
- Join Date
- Apr 2008
- Location
- Boston, USA
- Posts
- 13,175
- Thanks
- 744
- Thanked 699 Times in 550 Posts
- Blog Entries
- 4
- Feedback Score
- 4 (100%)
Cannot find either column dbo or the user-defined function or aggregate or the name is ambiguous - Microsoft SQL
Cannot find either column dbo or the user-defined function or aggregate or the name is ambiguous - Microsoft SQL
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)Free Classified Ads & BUSINESS/PROFESSIONAL SOCIAL NETWORK
Similar Threads
-
Ambiguous Words
By BrainPulse in forum General TalkReplies: 13Last Post: 02-06-2011, 10:17 PM -
jQuery, $ is Not Defined
By manik in forum JavaScript & AJAXReplies: 0Last Post: 12-30-2010, 06:49 PM -
$ is not defined - JQUERY
By manik in forum JavaScript & AJAXReplies: 0Last Post: 08-20-2010, 08:03 PM -
ambiguous or clear ads?
By himoacs in forum General MarketingReplies: 8Last Post: 07-04-2008, 10:43 PM -
How to find an invisible user on Y! messenger
By Amit.Verma in forum YahooReplies: 1Last Post: 07-02-2008, 08:26 AM


Reply With Quote

