I want to know what is the difference between MYSQL and MS SQL ? Which is best ? Max function in MS sql server supports numeric,character and datetime data types.
I want to know what is the difference between MYSQL and MS SQL ? Which is best ? Max function in MS sql server supports numeric,character and datetime data types.
Technical - As of versions 4.x MySQL does not support views, triggers, stored procedures, user defined functions, XML, while all these are suported by MS SQL
But MS SQL is an expensive proprietory RDBMS developed & owned by Microsoft Corporation while MySql is an open source RDBMS developed & maintained by MySQL AB of sweden with free as well as paid enterprise versions available.
Main differences between commonly used SQL in Microsoft SQL Query
Current Date and timing
MS SQL : SELECT GETDATE()
MY SQL : SELECT NOW()
Optionally: Use CURDATE() for the date only.
Trim function
MS SQL: LTRIM() and RTRIM()
MY SQL: TRIM()
Get List of Tables
MS SQL: SP_TABLES
MY SQL: SHOW TABLES
Find database version
MS SQL: SELECT @@VERSION
MY SQL: SELECT VERSION()
Bookmarks