Home Forums SQL Server 2008 SQL Server 2008 - General select top(100) percent RE: select top(100) percent

  • October 20, 2017 at 2:02 pm

    #1964587

    Lynn Pettis - Friday, October 20, 2017 10:39 AM

    jagjitsingh - Friday, October 20, 2017 10:37 AM

    Hi
     
      What is the use of select top(100) percent in a query in Sql 2008

    Thanks

    Sounds like auto-generated code.  It doesn't do anything and can be removed.

    If removed from a VIEW or CTE where there's also an ORDER BY clause, such removal will break the code unless the ORDER BY is also removed.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)