Modify columns' name in batches

Modify columns' name in batches.

GETANSINULL

Bring Array Mapping Capabilities to SQL

Simplify your SQL tasks by giving your queries and stored procedures the ability to iterate over arrays of table names or values.

TSQL Regular Expression Workbench

This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn't even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don't already use Regex with SQL Server.

Hidden RBAR: Triangular Joins

Just because it looks set based, doesn't mean it is. T-SQL Crackerjack Jeff Moden takes a look at a mistake that many query writers make.

Refresh All Views

Refresh All views in Current Database.

Rowcount

Unicode

Truncate v Delete

TSQL Lab I - Playing around with ROW_NUMBER

Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.