Nested Temporary Tables

T-SQL

Hidden Formatting Troubles with STR() (SQL Spackle)

Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.

Printing Lengths

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.