MySQL v MS SQL Stored Procedures

Posted on 2011-04-27
Last Modified: 2012-06-22
When it comes to SP I have limited experience but some.  I currently am in a MySQL environment and need to create and update many SPs.  I would like to purchase a good SP book but I'm not sure if it should be based on MySQL or MS SQL.  Is there that much of a difference in a MySQL SP and a MS SQL  SP??  Ideally I would like to purchase just one book.  I'm thinking maybe going with the MS SQL/SP book and using it for the MySQL environment as well.   I would appreciate any advise as to why I should get one or the other.


Question by:IRHusker
    LVL 15

    Accepted Solution

    this will basically depends on the level of complexity of your SPs...
    As you know, MS SQL sps are based on Transact SQL, which is a SQL language owned by Microsoft and it is rich on libraries that allow you to do things that are not conventional. The same thing would apply when comparing MySQL sps with Oracle PL/SQL.
    Now, as far as I know, MySQL sps are more standard and Mysql itself does not have any custom libraries as MS SQL and Oracle for example, making it more limited.

    So, in the scenario that you are more interested on basics for stored procedure wrting, maybe one book would suffice. But I truly believe that you will need books for each one of the databases.

    Author Closing Comment

    Very well put, thank you!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    This article describes some very basic things about SQL Server filegroups.
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now