The DELETE statement in SQL Server

Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd considering the extra power conferred on the statement by the addition of the WITH common_table_expression; and the OUTPUT clause that essentially allows you to move data from one table to another in one statement.

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.