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.

4. Group By Clause in SQLServer.

5. SQL SELECT STATEMENT.

6. MS SQL JOINS.