String Functions - SQL Server 2008 -- CHARINDEX

CHARINDEX ( expression1, expression 2, [starting position]) :This is one of the very important string functions in SQL Server. This function return the first position of a character or character string found within another character string. Here expression 1 is the string of character that would be searched in expression 2. Starting position is the index in expression 2 where CHARINDEX would start looking for expression 1 in expression 2.The index...

Read More

How to find stored procedure with specific text in the code

I came across a situation where I had to find the list of all such stored procedures defined in a specific database containing at least one cursor in their code. The following query worked for me.SELECT DISTINCT P.NAME FROM SYSCOMMENTS SCINNER JOIN SYS.procedures P ON P.OBJECT_ID = SC.IDAND P.NAME LIKE 'SP%' AND TEXT LIKE '%DECLARE%CURSO...

Read More

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