Table of Contents
MSSQL, T-SQL
Functions
Features and techniques
MSSQL, T-SQL
Functions
LPAD
Split
GetDateonly
Running processes and kill
Import data from excel
ExplodeDates - returns days in the given range as a table
Column to CSV
Features and techniques
Techniky T-SQL
Novinky MSSQL 2008
Test connection
Close connections
Common Table Expression
Shrink DB
Synchronize tables
SET IDENTITY
Reset identity
Disable printing number of affected rows
Fast COUNT
Reading CSV files
Send mail using CLR Stored Procedure
Restart MSSQL service
Backup
Miscellaneous