Articles tagged t-sql

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). Read more – ‘SQL User-Defined Function: ListToTable’.
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. Read more – ‘SQL User-Defined Function: ReplaceChars’.