String Functions - SQL Server 2008

String functions operate on a string input value, and return a string or a numeric value. All built in string functions are deterministic, as they return the same result for a given set of values. Below we would discuss each function in detail with examples.ASCII(character) :This function returns ASCII values against the input character.Example:This function take single character as a parameter, if you provide it a string of character. It will give...

Read More

Functions in SQL Server 2008

A function performs operation on a given set of values and return a value. In Sql server, built in functions are either deterministic or non-deterministic. Deterministic Functions:A function is said to be deterministic if it returns same result at any time it is called for a specific set of input values.DATEADD is a built-in deterministic function, as it returns the same value, when ever it is run on a specific set of values. Non Deterministic Functions:If a function returns different values each time it is called then it is said to non deterministic...

Read More