|
Posted by Carl Tegeder on 02/27/07 00:36
Sounds like you need to take a look at this URL:
http://msdn2.microsoft.com/en-us/library/ms379594(VS.80).aspx though
I doubt a newb will understand it much. This is just in case there are
other "MVP's" like myself who are in need of a good reference for a
task like large query input.
HTH,
Carl Tegeder
Master MS-SQL Administrator
MS-SQL MVP
On Feb 26, 12:36 pm, t...@makaro.com wrote:
> Could someone please point me in the right direction on how to read in
> a large query with .net.
>
> I am trying to emulate a legacy database system so I don't know the
> upper bounds of the sql query. An example query would be something
> like:
>
> Select * from invoices where year > 1995
>
> the query must be updatable and only return say 10 to 100 rows at a
> time.
> It should also be forward only and discard rows no longer in use to
> save memory.
>
> And if at all possible I would like to lock one row at a time as the
> row is read in.
Navigation:
[Reply to this message]
|