There are IMHO 3 major differences between MySQL and SQLServer.

  • MySQL does not support stored procedures
  • MySQL does not support subqueries
  • SQLServer only supports 1 statement handle per DB connection

    • All of these can be coded around, but I would strongly urge you to consider PostgreSQL (Which has none of those 3 limitations). PostgreSQL only has one thing I consider a limitation, which is lack of formal replication support (which there are several informal methods). If you really want to get into the minutia you can compare all 3 with crash-me

    As side notes (read: just my opinion)-

    I really don't care for SQLServer's logging, to me it seems very much feast or famine - You are either wading through hundreds of worthless messages or you get almost nothing.

    MySQL transaction support is fairly new. (not that it's bad, just new)



    grep
    Mynd you, mønk bites Kan be pretti nasti...

    In reply to Re: MySQL vs SQL2000 by grep
    in thread MySQL vs SQL2000 by true

    Title:
    Use:  <p> text here (a paragraph) </p>
    and:  <code> code here </code>
    to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.