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 |
