- SQL User-Defined Function: ListToTable
-
Monday, 22nd September 2008
A common need in SQL is the ability to iterate over a list as if it were an array. In SQL it is not possible to declare arrays, unlike other programming languages such as ColdFusion, ActionScript and Java. Fortunately, there is a way around this problem: use a User-Defined Functions (UDFs) to create a tabular version of the data. Arrays are, after all, essentially tabular data (at their simplest, one dimension level).
Tags: ActionScript, array, data, database, database server, extend, function, Java, SQL, sub-routine, subroutine, t-sql, tabular, UDF, user defined function
- SQL User-Defined Function: ReplaceChars
-
Friday, 19th September 2008
The SQL Replace function enables us to look for a certain character phrase in a string and replace it with another character phrase. The updated string is then returned by the function.
Tags: database, database server, extend, fairly straight forward, function, Microsoft, Oracle, SQL, sub-routine, subroutine, t-sql, UDF, user defined function