Microsoft SQL Server

Syntax differences between MySQL and MSSQL

MySQL	MSSQL
AUTO_INCREMENT	IDENTITY(1,1)
UNSIGNED	not valid
SELECT * FROM foo LIMIT x	SELECT TOP x * FROM foo
SELECT * FROM foo LIMIT x,y	not sure how to implement yet
IF(cond,trueVal,falseVal)	CASE WHEN cond THEN trueVal ELSE falseVal END
SHOW TABLES	SELECT * FROM INFORMATION_SCHEMA.TABLES

MSSQL Variables

@@VERSION	Server version information
@@IDENTITY	Last inserted row
@@ERROR	Last error number

See also

• MSSQL reference
• Type casting