SQL CLR Function for Email validation and string Split

I have added 2 functions here, one for email validation and another to split the string by specified separator by user.

SQL Script to generate columns for triggers

SQL Script to generate columns for triggers

What is the result of the following query

Build date table

Eval arithmetic statement function in SQL

This function evaluates the statement like '4+5*6-3' and returns the numeric value.It is just like Eval funcction in javascript.

Nulls

Group Islands of Contiguous Dates (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.

LIKE and = Operators

Returning the Top X row for each group (SQL Spackle)

One of the most common T-SQL questions is on returning a ranked result set for each member of a group. Dave Ballentyne brings us a short tutorial on how you can do this in T-SQL.

sys.syscomments