mysql to sql server

before i am using mysq开发者_如何学JAVAl and now using sql server, does it have the same syntax? thanks.

---

The basic syntax is the same "SQL" standard, but a lot of stuff is not. For example in MySQL you'd write .. LIMTIT 0,3 .. while in MSSQL you have to use the TOP syntax.

You're best off with it if you use a Database abastraction layer. This may help you too:
http://www.tometasoftware.com/MySQL-5-vs-Microsoft-SQL-Server-2005.asp

MySQL vs Microsoft SQL

---

SQL uses ANSI and ISO standards. You may find that you'll need to change a few queries where you are using MySQL specific keywords like LIMIT for example.