SQLServerCentral Logo SQLServerCentral Logo
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Register
  • Login
  • Write for us
  • Menu
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Write for us
  • Register
  • Login

Home Forums SQL Server 2008 SQL Server 2008 - General “SELECT 1″ rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”. RE: “SELECT 1? rather than a “SELECT *” when using an EXISTS or a NOT EXISTS clause”.

  • BrainDonor

    SSCoach

    Points: 19273

    More actions

    February 10, 2011 at 5:00 am

    #1285083

    http://www.sqlservercentral.com/Forums/Topic786650-338-1.aspx

    http://www.sqlservercentral.com/Forums/Topic453737-338-1.aspx

    Marginal differences, it would appear.

    BrainDonor.

    Steve Hall
    Linkedin
    Blog Site

    • About SQLServerCentral
    • Contact Us
    • Terms of Use
    • Privacy Policy
    • Contribute
    • Contributors
    • Authors
    • Newsletters
    Redgate logo