actually i am a computers engineering student and i want to learn a database. someone told me that the syntax of both microsoft sql and mysql is same- meaning that if i learn mysql, i will also be able to work on microsoft sql. is this true? and what should i learn?
2006-12-24 04:26:41 · 4 answers · asked by Rishabh Singla 2 in Computers & Internet ➔ Programming & Design
The SQL standard is governed by ANSI, so you notice a database supports say ANSI-92 SQL.
The difference between MS-SQLServer and MySql is one of open versus proprietary. MySql is free and is arguably used more than any other RDBMS to support the web. MS-SQLServer is a Microsoft product, which you normally have to pay for.
2006-12-24 04:29:44 · answer #1 · answered by anothersillypersonalsname 2 · 0⤊ 0⤋
MySQL is Free and opensource. MS SQL is costly database. If you are doing to develop application for web, you can go with MySQL. If you need transactional database for financial application, you need MS SQL.
Yujin
www.scriptinstallation.in
2006-12-24 04:31:10 · answer #2 · answered by vu3prx 2 · 0⤊ 0⤋
For database fundamentals u can learn from assess database,But for Sql Server is the best for applications.
2016-05-23 04:03:47 · answer #3 · answered by Anonymous · 0⤊ 0⤋
And once you get sucked into Microsoft products you find you need other things to make it all work, none of which are free or cheap.
2006-12-24 04:46:59 · answer #4 · answered by drhowarddrfine 2 · 0⤊ 0⤋