Difference between revisions of "Microsoft SQL Server"
From Organic Design wiki
m |
|||
| Line 27: | Line 27: | ||
== See also == | == See also == | ||
*[http://msdn.microsoft.com/en-us/library/ms188783.aspx MSSQL reference] | *[http://msdn.microsoft.com/en-us/library/ms188783.aspx MSSQL reference] | ||
| + | *[http://doc.ddart.net/mssql/sql70/ca-co_1.htm Type casting] | ||
Revision as of 21:41, 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 |
