All topics
Database / 24 guides
SQL Server
T-SQL for transformations, strings, dates, pivots and system metadata.
Everyday queries
Strings
Dates and times
Pivot and unpivot
System information and structure
- How to query the version of SQL Server
- How to find numeric columns in a temporary table
- How to ADD COLUMN to existing TABLE
- How to find all tables with a specified COLUMN
- How to find all stored procedures that contain a word in SQL Server
- How to add constraints to existing table
- How to check if a table contains rows