http://www.sqlservercentral.com/Content tagged User-Defined functions posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Computed columns in SQL Server 2000 allow you to have a calculated value available easily in a query. However by using a function instead of a simple formula you can build some very interesting solutions. New author Tim Chapman brings us a look at this technique. http://www.sqlservercentral.com/articles/User-Defined+functions/complexcomputedcolumns/2397/2006/05/09http://www.sqlservercentral.com/articles/User-Defined+functions/complexcomputedcolumns/2397/SQL Server string manipulation using T-SQL leaves lots to be desired. Many postings and complaints about T-SQL deal with strings, but there are ways to work with it. Author Eli Leiba brings us a way to split out portions of a string that contains tokens with a user defined function. Read on to see how this is accomplished and the code used to perform the splitting. http://www.sqlservercentral.com/articles/User-Defined+functions/tokenizingastringusingparsename/1632/2004/12/27http://www.sqlservercentral.com/articles/User-Defined+functions/tokenizingastringusingparsename/1632/Many programming languages have supported User Defined Functions for years, but they are new to SQL Server 2000. In this article we will look at some of the ways functions can be used within SQL Server 2000. http://www.sqlservercentral.com/articles/User-Defined+functions/userdefinedfunctions/147/2004/10/22http://www.sqlservercentral.com/articles/User-Defined+functions/userdefinedfunctions/147/User defined functions were added in SQL Server 7 and enhanced in SQL Server 2000, but they are still a relatively little used feature. Here's a look at a unique way that Leo Peysakhovich solved a problem using a UDF. http://www.sqlservercentral.com/articles/User-Defined+functions/exoticuseofuserdefinedfunction/1450/2004/09/07http://www.sqlservercentral.com/articles/User-Defined+functions/exoticuseofuserdefinedfunction/1450/Dinesh looks at the date functions, how to work with time zones (or not), and does a brief comparison to see how you do similar tasks in Oracle. http://www.sqlservercentral.com/articles/Advanced+Querying/datetimevaluesandtimezones/1234/2003/12/22http://www.sqlservercentral.com/articles/Advanced+Querying/datetimevaluesandtimezones/1234/Dinesh is back with another article on user defined functions, giving some more great examples. If you haven't read the first one, definitely go back and read it first. http://www.sqlservercentral.com/articles/User-Defined+functions/udfascomputedcolumnpart2/1054/2003/07/14http://www.sqlservercentral.com/articles/User-Defined+functions/udfascomputedcolumnpart2/1054/UDF's are useful if somewhat tricky. Dinesh uses a common scenario where you have a self referencing table (the common example is an employees table where each employee has a managerid that links to another employee in the same table) to illustrate how a UDF can make querying easier, how to use it as the basis of a computed column, and how to index that column. http://www.sqlservercentral.com/articles/User-Defined+functions/udfascomputedcolumn/1025/2003/06/18http://www.sqlservercentral.com/articles/User-Defined+functions/udfascomputedcolumn/1025/Vicktor has a bunch of scripts he uses to monitor performance, he explains why he built them and how to use them. Good coverage of the different reasons for slow performance. http://www.sqlservercentral.com/articles/Performance+Tuning/monitoringperformance/1007/2003/06/09http://www.sqlservercentral.com/articles/Performance+Tuning/monitoringperformance/1007/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now! http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/2002/06/04http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/Alxander Chigrik presents some useful User Defined Functions you can add to your SQL Server. http://www.sqlservercentral.com/articles/User-Defined+functions/udfexamples/528/2001/12/19http://www.sqlservercentral.com/articles/User-Defined+functions/udfexamples/528/Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects. http://www.sqlservercentral.com/articles/User-Defined+functions/metadataudfs/448/2001/10/17http://www.sqlservercentral.com/articles/User-Defined+functions/metadataudfs/448/Alexander Chigrik presents a few Math UDFs he has developed for common functions.http://www.sqlservercentral.com/articles/Basic+Querying/mathudfs/447/2001/10/09http://www.sqlservercentral.com/articles/Basic+Querying/mathudfs/447/The User_Defined_Functions.exe file contains the User-Defined Functions white paper. The User-Defined functions white paper outlines the characteristics of the new user-defined function (UDF) feature that is introduced in Microsoft SQL Server 2000. The white paper also summarizes how you can create your own Transact-SQL functions to extend the programmability of Transact-SQL. http://www.sqlservercentral.com/redirect/articles/381/2001/08/31http://www.sqlservercentral.com/redirect/articles/381/Many programming languages have supported User Defined Functions for years, but they are new to SQL Server 2000. In this article we will look at some of the ways functions can be used within SQL Server 2000. http://www.sqlservercentral.com/articles/User-Defined+functions/userdefinedfunctions/147/2004/10/22http://www.sqlservercentral.com/articles/User-Defined+functions/userdefinedfunctions/147/