SQL Tricks

These are MS Sql Server codes:

1. HOW TO CONVERT TIMESPAN DATA COLUMN INTO AM/PM IN SQL SERVER.

2. HOW TO DYNAMICALLY ALTER COLUMNS IN ANY TABLE IN SQL SERVER.

3. HOW TO INCREMENT ALPHANUMERIC NUMBER IN SQL SERVER.