LagDaddy's SQL Wizardry Blog
About Me
Name:
Eddie
Location:
Texas, United States
I don't feel or think as old as I am.
View my complete profile
Links
My Main Blog
My Personal Web page
My Computing Tips Blog
My SQL Wizardry Blog
My Web Application Building Blog
My Graphics Blog
My World of Warcraft Blog
Previous Posts
Search all columns of all tables in a databse
What I learned today...
How to group some results at the top...
How many records were updated with my CF update qu...
Another way to get the identity of a new record
SQL Reference
Example of looping through query results AND condi...
Get the id of a newly created record
Get Customer and most recent status
Eliminating Dupes and still getting IDs
Archives
February 2005
March 2005
September 2005
January 2006
September 2006
January 2007
February 2007
May 2007
June 2007
November 2007
February 2008
June 2008
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;
posted by Eddie @
1:45 PM
0 comments