Difference between revisions of "Microsoft SQL Server"
From Organic Design wiki
(New page: == Syntax differences between MySQL an...) |
m |
||
| Line 1: | Line 1: | ||
== Syntax differences between MySQL and MSSQL == | == Syntax differences between MySQL and MSSQL == | ||
| − | {| border | + | {| border cellspacing=0 cellpadding=4 |
!MySQL!!MSSQL | !MySQL!!MSSQL | ||
|- | |- | ||
| Line 17: | Line 17: | ||
== MSSQL Variables == | == MSSQL Variables == | ||
| − | {| border | + | {| border cellspacing=0 cellpadding=4 |
|@@VERSION||Server version information | |@@VERSION||Server version information | ||
|- | |- | ||
Revision as of 21:36, 9 May 2008
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 |
