[dba-SQLServer] Testing UDFs

That isn't getting it.

SELECT Top (100) percent ank_, Addr, udf_AddrValid(ank_,Addr) as Expr1
 From dbo.TblAZData
Where...
Order By ...

Whether I throw a dbo. in there or not I get an error that udf_AddrValid is not a builtin function name.

John W. Colby
www.ColbyConsulting.com


Doris Manning wrote:
> Dbo.uf_AddrValid 
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Saturday, July 04, 2009 9:36 AM
> To: Dba-Sqlserver
> Subject: [dba-SQLServer] Testing UDFs
> 
> I am jumping into writing UDFs this morning.  I need to test the results.
> When I write a query to pull data from a table using the UDF as one of the
> columns (just to display what happens) I get:
> 
> "uf_AddrValid not a recognized built-in function name."
> 
> Is there a naming convention to allow SQL Server (2005) to understand my UDF
> and use them?  I know that there was a prefix I had to use in stored
> procedures.
> 
> --
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>