T-SQL FAQ

How To Get Last Inserted ID On SQL Server
Explains how to get last table ID in different scenarios on SQL Server.

Using INSERT INTO
Explains how to use INSERT INTO to insert one or more records to database.

How To Use T-SQL To Subtract Dates And Calculate Time Span?
Explains two common ways to subtract datetime or smalldatetime data types on SQL Server.

T-SQL Reserved Words List
A list of T-SQL reserved words used by SQL Server to define SQL statements.

How To Enable Full Text Search With T-SQL?
Explains how to use T-SQL to enable Full Text Search on SQL Server.

Check If Database Exists Using T-SQL
Explains how you can check if database exists on SQL Server using T-SQL code.

IndexOf() Function in T-SQL?
Explains an options how to simulate .Net IndexOf() and LastIndexOf functions in T-SQL.