Results 1 to 2 of 2

Thread: Difference between MY-SQL and MSSQL

  1. #1
    Join Date
    Jun 2009
    Posts
    106

    Thumbs up Difference between MY-SQL and MSSQL

    MySQL does not support Triggers, SQL Server does.
    MySQL does not support User Defined Functions, SQL Server does.
    MySQL does not have Cursor Support, SQL Server does.
    MySQL does not support Stored Procedures, SQL Server does.
    MySQL does not have FULL JOIN capabilities, SQL Server does.
    MySQL has limited Import/Export capabilities, SQL Server has full support for Import/Export.
    MySQL has limited Transaction Support while SQL Server offers full Transaction Support.

  2. #2
    Join Date
    Jul 2009
    Location
    India
    Posts
    213

    Default

    MSSQL : Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query languages are MS-SQL and T-SQL.

    MySQL is a relational database management system (RDBMS)
    1. which has more than 11 million installations.
    2.The program runs as a server providing multi-user access to a number of databases.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •