Difference between revisions of "Microsoft SQL Server"

From Organic Design wiki
m
m
Line 16: Line 16:
 
|-
 
|-
 
|SHOW TABLES||SELECT * FROM INFORMATION_SCHEMA.TABLES
 
|SHOW TABLES||SELECT * FROM INFORMATION_SCHEMA.TABLES
 +
|-
 +
|ENUM||''not natively supported, change to text''
 
|}
 
|}
  

Revision as of 07:12, 10 May 2008

Syntax differences between MySQL and MSSQL

MySQL MSSQL
AUTO_INCREMENT IDENTITY(1,1)
bool bit
[UN]SIGNED 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
ENUM not natively supported, change to text

MSSQL Variables

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

See also