This article covers all the basics of User Defined Functions. It discusses how (and why) to create them and when to use them. It talks about scalar, inline table-valued and multi-statement table-valued functions.
I appreciate the info, but for me a HUGE piece is missing. The article says it discusses how to create UDFs, but I don't see the part where we're told how to get those nifty functions into SQL Server. As a new SS developer that's the part I need the most and can't find anywhere.
>>I don't see the part where we're told how to get those nifty functions into SQL Server
Did you see all the CREATE FUNCTION statements? That's how you create a function in SQL Server. If that's not what you mean, can you be more specific about what you need?
>>I don't see the part where we're told how to get those nifty functions into SQL Server
>>Did you see all the CREATE FUNCTION statements? That's how you create a function in SQL Server. If that's not what you mean, can you be more specific about what you need?
>> Well, you should use SQL Query Analyzer in SQL Server 2000 to type the CREATE FUNCTION command in. Once you complete the command you can execute it by pressing F5 and you're done.
Hmmmmm....you might want to search the forum before you point people to a page entitle "Best" Split UDF function....
There are methods which do not require a loop or a temporary table. There is a whole thread devoted to the topic here.
________________________________________________ If it is not practically useful, then it is practically useless. ________________________________________________
Article: User Defined Functions
Posted - 10/12/2000 : 00:28:17
