DECLARE @myVar INT
INSERT ....
SET @myVar = @@ROWCOUNT
OR
INSERT ....
SELECT @@ROWCOUNT AS myVar
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, 14 February 2004 1:05 AM
To: CF-Talk
Subject: Update query record count?
Is there a way to see how many (if any) records an update query has updated
after it runs? Recordcount doesn't work.. Is there a way without doing
another
query?
Thanks,
Chris
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
