Groups > comp.databases.ms-sqlserver > #924

Select affected rows

From	omtechguy <omtechguy@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Select affected rows
Date	2012-02-05 01:19 -0800
Organization	http://groups.google.com
Message-ID	<93b61b75-3623-40cb-943e-84afb1451403@dp8g2000vbb.googlegroups.com> (permalink)

Show all headers | View raw

Hi,

is there an option to get the identities of the affected rows and not
only a counter that mention the number of the affected rows?

Another question, is there an (NOLOCK) equivalent option for update
statement?

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Select affected rows omtechguy <omtechguy@gmail.com> - 2012-02-05 01:19 -0800
  Re: Select affected rows bradbury9 <ray.bradbury9@gmail.com> - 2012-02-05 05:04 -0800
  Re: Select affected rows "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-02-07 07:30 -0500
    Re: Select affected rows Erland Sommarskog <esquel@sommarskog.se> - 2012-02-07 12:54 +0000
      Re: Select affected rows "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-02-07 10:33 -0500
    Re: Select affected rows bradbury9 <ray.bradbury9@gmail.com> - 2012-02-07 07:03 -0800
  Re: Select affected rows Erland Sommarskog <esquel@sommarskog.se> - 2012-02-07 12:56 +0000

csiph-web