[dba-SQLServer]UDFs

UDFs are something I simply have been unable to wrap my mind around.  I
guess they are a new tool that I have always gotten along without.  Does
anybody have any recommendations for a good, VERY PRACTICAL book or tutorial
on them?  Anybody have any examples close at hand that demonstrate how
useful they are?

TIA  D. Lewis

> 
> 
> ------------------------------
> 
> Message: 5
> Date: Tue, 6 May 2003 12:19:06 -0400
> From: "Arthur Fuller" <artful at rogers.com>
> Subject: RE: [dba-SQLServer]Sproc Output to VB?
> To: <dba-sqlserver at databaseadvisors.com>
> Message-ID: <027e01c313eb$37aa3610$8e01a8c0 at Rock>
> Content-Type: text/plain;	charset="US-ASCII"
> 
> I too find it too cumbersome to write all that front end code 
> that creates a
> command object and bla bla bla bla bla. When I need something back,
> typically I write a UDF that returns either a scalar value or a table,
> depending on how many values I need back. The more I use UDFs 
> the more I
> love them.
> 
> Arthur
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Djabarov,
> Robert
> Sent: May 6, 2003 10:15 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer]Sproc Output to VB?
> 
> 
> It is not necessarily such a clear cut.  I don't use output 
> params at all,
> but rather return the result of action queries in the form of 
> a recordset (1
> row 1 column).  All processing logic sits on the server.
> 
> Robert Djabarov
> Senior SQL Server DBA
> USAA IT/DBMS
> ? (210) 913-3148 - phone
> ? (210) 753-3148 - pager
> >