heterogeneous query how do I get correct @@rowcount ?
- From: Ian_Add <IanAdd@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 23 Oct 2009 11:25:01 -0700
Hi. Writing a Stored Proc which read some data from a remote Oracle database
and ultimately writes some data into my SQL Server 2000 database. @@rowcount
is returning a value related to the number of remote records I read and not
how many I ultimately wrote into local SQL database.
Looking for one of two solutions:
a) the right way to beat this issue elegantly
b) My workaround results in me doing a select @writecount = count(*) from a
copy of 'select' I will ultimately write, then repeat the select statement
with the insert. Is there a better way?Thanks
Ian
.
- Follow-Ups:
- Re: heterogeneous query how do I get correct @@rowcount ?
- From: Jeroen Mostert
- Re: heterogeneous query how do I get correct @@rowcount ?
- Prev by Date: Re: Exclude records using a select statement
- Next by Date: Re: exec master.dbo.xp_ versus exec master..xp_
- Previous by thread: Exclude records using a select statement
- Next by thread: Re: heterogeneous query how do I get correct @@rowcount ?
- Index(es):
Relevant Pages
|
