Difference between revisions of "Microsoft SQL Server"
From Organic Design wiki
m |
|||
| Line 5: | Line 5: | ||
|AUTO_INCREMENT||IDENTITY(1,1) | |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||SELECT TOP x * FROM foo | ||
Revision as of 23:27, 9 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 |
MSSQL Variables
| @@VERSION | Server version information |
| @@IDENTITY | Last inserted row |
| @@ERROR | Last error number |
