Pounds of Formatting Fun

Arithmetic Operation Results

Global Cursors

SubQuery behavior

PatReplace8K

This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.

LEAD parameters

T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements

Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.

Standardize Object Names

Rename all database objects to use a standardize naming convention.

Dynamic Table Name on Select Into

Based upon todays date as suffix and chosen string as prefix, select data from predefined table into dynamically named new table. Script is properly error handled with most common errors

COALESCE in Left Join