It's a common request to get a list of people whose birthday (or an anniversary date) falls into specified date range w/o regard to the year.

It's a common request to get a list of people whose birthday (or an anniversary date) falls in the specified date range w/o regard to the year.

T-SQL has CHARINDEX and PATINDEX functions that return the position of one character expression in another. The ufn_AT and ufn_RAT functions add the ability to search for specified occurrences and to search from right to left.

The functions such as DELETED(), RECNO(), etc., which accept an optional workarea alias, could yield unexpected results when used in queries incorrectly.

The SELECT - SQL Command with INTO CURSOR clause can create a filtered cursor under following conditions:

• Only one table is referenced by the query
• WHERE condition is fully optimizable and can be represented by SET FILTER TO command
• In the Select list either '*' specified (all fields) or subset of the fields from the table
• No additional clauses, like DISTINCT, ORDER BY, GROUP BY, etc., are present
• SET EXACT and SET ANSI settings match

Source: How to identify your SQL Server version and edition