On 05 Nov 2003 09:51:02 GMT, hrishikesh musale
<mu*****@mahindrabt.com> wrote:
hey does anybody know what are these in UDF's in SQL2k?
You use UDFs to return a "computed" result per row of a query. You use
stored procedures to return a single set of data. They really have
different uses; stored procedures are much more akin to what
relational databases are for.
The typical use I've had for UDFs is to perform row-based calculations
based on data lookups. For example, if you have a table that stores
shift begin and end times per line, you could create a UDF to look up
the shift of any data based on the record entry time and the line ID,
and use that in your stored procedure. This would be very There are
other uses along these lines.
--
to replay by email, chop off the head!