Home | User-Defined Functions | Tips & Tricks | SQL Server 2005 | Forums | Frequently Asked Questions | Practice Test |    
 
Date Functions
Get Age Computes for the age given the birth date and the reference date.
Determine Leap Year Determines whether the input date is a leap year or not.
Get First Day of the Week Returns the first day of the week for a given date.
Get First Day of the Month Returns the first day of the month for a given date.
Get First Day of the Quarter Returns the first day of the quarter for a given date.
Get Last Day of the Month Returns the last day of the month for a given date.
Get Date Only Returns the input date removing the time portion.
Get Number of Days in a Month Returns the number of days in a month.
Get Number of Days in a Year Returns the number of days in a year.
String Functions
Count Character Occurrence Returns the number of times a given input character exists in a given input string.
Count String Occurrence Returns the number of times a given search string exists in a given input string.
Count Words Returns the number of words in a given input string.
InitCap / String Capitalization Emulates the behavior of Oracle's InitCap string function, which changes the first letter of each word in uppercase and all others in lowercase.
Simple String Encryption/Decryption A string encryption and decryption function that uses a simple algorithm to encrypt and decrypt string values.
Trim Leading Zeros Trims the leading zeros of an alphanumeric value.
Tree Functions
Get Tree Path Returns the path of a node from the parent to the current node in a hierarchical/tree-type table.
Get Tree Node Level Returns the level of a given node in a hierarchical/tree-type table.
Table-Valued Functions
Integer Range Table Returns a table containing integer values from 1 to a maximum value.
Comma-Delimited Value to Table Returns a table containing the comma-delimited value parameter as separate records.