Additional filters:

Currency Filesystem Function Rowset SQL Server Strings Datetime Formatting Numeric Snippet String

Sort By:

Name Last Updated Ascending Descending

Articles: Format Currency  Easy currency formatting of numbers in SQL Server using a scalar function. Last modified 2/9/2013

Articles: Format Number and Decimal Value  Easy formatting of numbers in SQL Server using a scalar function. Last modified 2/9/2013

Articles: Get Days Of Month  Returns a table with one row per day of a given year and month. Last modified 2/10/2013

Articles: Get First and Last day of Month  Two simple functions to get the first and last day of a month. Last modified 2/9/2013

Articles: Proper Name Casing in SQL Server  Need to format a name for a form? Well, this isn't perfect by any means, but it's a start. Last modified 2/8/2013

Articles: Read File as Table  Allows you to easily select from a file on the file system as if it were a table. Last modified 2/17/2013

Articles: Row List  Returns a table with a given number of rows. Last modified 2/9/2013

Articles: Split Array  SplitArray is a powerful table SQL function which splits delimited values into a row-set. Last modified 2/17/2013

Articles: String and Numeric Padding  SQL functions used to left and right pad a values with 0s (or some other value), Last modified 2/9/2013