Tuesday, November 13, 2007

How many records were updated with my CF update query?

Thanks to Mike O. for finding this:

SET NOCOUNT ON;
BEGIN TRANSACTION;


UPDATE tblApplicant
SET frozen = 1
WHERE ...

SELECT @@rowcount AS changes;

COMMIT TRANSACTION;
SET NOCOUNT OFF;

0 Comments:

Post a Comment

<< Home