Post reply

count without using count function

  • February 7, 2009 at 4:29 pm

    #130611

    Hi all

    is there a way to retrieve records limiting based on some number but without using count function

    Thanks in advance

  • February 7, 2009 at 6:49 pm

    #940086

    Checkout the SELECT statement's "TOP (X)" clause in Books Online.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • February 7, 2009 at 10:33 pm

    #940100

    Please don't double post.

    With that said, you can also use the

    SET ROWCOUNT XXX

    This affects the very next query in the process and will return the number of rows specified above. This is suppose to only work with Select statements. UPDATE, DELETE, and INSERT are being deprecated in 2008 last I read in BOL.

    I am not sure which is more efficeint though from a performance standpoint

    Fraggle.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply