Microsoft SQL Server

From Organic Design wiki
Revision as of 21:41, 9 May 2008 by Nad (talk | contribs)

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