Microsoft SQL Server - Migration Reference

SQL Language Elements

+ String Concatenation Operator

Data Types

Datetime data types:

1

DATE

Date (year, month and day)

Since SQL Server 2008

DATETIME or DATETIME2(3)?

Other data types:

1	BIGINT		64-bit integer
2	NCHAR(n)	1 ⇐ n ⇐ 4000	Fixed-length string in Unicode UCS-2
3	NVARCHAR(n)	1 ⇐ n ⇐ 4000	Variable-length string in Unicode UCS-2
4	NVARCHAR(max)	2 GB
5	TIMESTAMP and ROWVERSION		Auto-updated binary
6	TINYINT	0 to 255	8-bit unsigned integer

Built-in SQL Functions

Built-in functions in SQL Server:

1	DATEDIFF(units, start, end)	Get datetime difference in the specified units
2	@@ERROR	Get last error code
3	LEFT(string, n)	Return n leftmost characters from string
4	RIGHT(string, n)	Return n rightmost characters from string
5	RTRIM
6	STR(float, len, decimal)	Convert float to string
7	YEAR(datetime)	Extract year from datetime

Statements

CREATE INDEX

Database Migration Issues

Database Settings

How To - Transact SQL

Create Table-Valued User-Defined Functions

SQL and Transact SQL

SQL Batch and GO Statement
SELECT Into Variable When Multiple Rows Returned
Local and Global Temporary Tables (Emulating Oracle Package Variables)
Migrating Oracle Sequences to SQL Server 2008
Transact SQL Errors Appearing During Runtime Execution Only (Testing T/SQL Code After Conversion)

SQL Server Metadata

Select All Tables in All Databases (Transact-SQL Script)
Drop All References (Foreign Keys) to the Specified Parent Table (Transact-SQL Script)

Instances and Connections

SQL Server Performance