CODEWITHSUNDEEP
sqlsql-serverstored-proceduresuser-defined-functions
Ahmet Altun
Ahmet Altun

Reputation: 4039

SQL Inline Function

I have a User Defined Function on database named MyFunc. It takes a string parameter and returns a scalar value.

And MYTABLE has two columns: ID, NAME

So Why is the following query error?

SELECT ID, MyFunc(NAME)
FROM MYTABLE

Upvotes: 1

Views: 843

Answers (1)

amit_g
amit_g

Reputation: 31250

Qualify it with schema

SELECT ID, dbo.MyFunc(NAME)
FROM MYTABLE

post the function if it doesn't work.

Upvotes: 4

Related Questions