UPDATE

• Hari Takella-174750

  SSC Enthusiast

  Points: 191

  More actions

  November 12, 2004 at 12:09 pm

  #84101

  Hi,

  Is there a way that we can update only the top 50 rows and leave the remaining or something. I want to use this in debugging, because my update does for million rows and i just have to wait 4 hrs to complete the whole update statement

  thank you for your help

  Hari

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  November 12, 2004 at 12:51 pm

  #529997

  from BOL:

  SET ROWCOUNT

  Causes Microsoft® SQL Server™ to stop processing the query after the specified number of rows are returned.

  Syntax

  SET ROWCOUNT { number | @number_var }

  Arguments

  number | @number_var

  Is the number (an integer) of rows to be processed before stopping the given query.

  There is no "i" in team, but idiot has two.