Detecting changes during insert/update

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

nigelrivett SSCertifiable Points: 5472 More actions · Answer 1

You can use sp_executesql to run the d-sql - set a return parameter from @@rowcount and return that.

There is an example of using sp_executesql to return parameters from d-sql and d-sql SP calls at

sp_executeSQL

Cursors never.
DTS - only when needed and never to control.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

Hey!!!

Where's our link!!!!!!!!!!!!!!!!!!1

BTW, Nice answer to this question.

Steve Jones

nigelrivett SSCertifiable Points: 5472 More actions · Answer 3

Sorry - that site (amazing grapics!) is hosted by ntl and I've lost the ability to update it.

I'll add you when I move it somewhere else. Plan to host it at home but paid work keeps getting in the way.

I started it to hold the sp_executesql item as I can never remember the syntax and the help is not very clear.

Cursors never.
DTS - only when needed and never to control.

GRN Hall of Fame Points: 3260 More actions · Answer 4

This should work for you

DECLARE @sql Nvarchar(500),

@Var NVarchar(100)

@rc int

SET @Var = '@RC int output'

SET @sql = 'UPDATE authors set phone = phone where contract = 1 SELECT @li = @@ROWCOUNT'

EXEC @sql , @Var , @rc

PRINT @rc

GRN Hall of Fame Points: 3260 More actions · Answer 5

Sorry , This is the right answer , i've used the pubs database for the sample query

DECLARE @sql Nvarchar(500),

@Var NVarchar(100),

@rc int

SET @Var = '@RC int output'

SET @sql = 'UPDATE authors set phone = phone where contract = 1 SELECT @li = @@ROWCOUNT'

EXEC Sp_ExecuteSql @sql , @Var , @rc OutPut

PRINT @rc