> > > I spent a few minutes looking at SQL Server Books Online,
> > > and couldn't find anything which SQL Server would automatically
> > > return how many records were updated by a query. You can use the
> > > RETURN keyword within a stored procedure to return a value, or
> > > you could use RAISERROR to throw an error, but I didn't find what
> > > you're looking for, and I don't think it exists, at least not in
> > > SQL Server.
> >
> > what about @@ROWCOUNT? it returns the number of rows
> > affected by the last sql statement.....
>
> That's what I used in the sample trigger I included earlier in this
thread,
> but as far as I know, your query itself has to actually reference
@@ROWCOUNT
> and specifically return it; it won't just "be there" in your application
if
> you don't.
It *will* just "be there".
Nick de Voil
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
