Re: Returning intermediate results from a stored procedure
From: Brian (bcap_at_IHATESPAMclara.co.uk)
Date: 02/24/05
- Next message: David Portas: "Re: need help with procedure"
- Previous message: Roji. P. Thomas: "Re: need help with procedure"
- In reply to: Carl Imthurn: "Re: Returning intermediate results from a stored procedure"
- Next in thread: Tibor Karaszi: "Re: Returning intermediate results from a stored procedure"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 10:36:09 -0000
"Carl Imthurn" <nospam@all.com> wrote in message
news:umE%23yifGFHA.3612@TK2MSFTNGP09.phx.gbl...
> Thanks for your reply, Tibor.
> I tried both of them in QA and for some reason they both waited 7 seconds
and then printed
> 'hello' and 'there' at the same time.
> I don't know if a configuration setting needs to be changed, but
regardless of that,
> reading the rest of your post, you lost me, technically speaking.
> (my fault, not yours, I assure you) :-)
> Anyway, thanks again for your time - I appreciate it.
>
> Carl
>
> Tibor Karaszi wrote:
>
> > Theoretically, you can add RAISERROR command in between and use the
NOWAIT option to the RAISERROR
> > command. This means that SQL Server flushes the output buffer so the
data in the buffer so far is
> > sent to the client. In order to take advantage of this in the client
applications, you need to
> > program asynchronously (obviously, otherwise the call to the db API
function is just sitting there
> > until the whole procedure has executed). Try below from QA and you'll
see the difference:
> >
> > Compare below:
> >
> > PRINT 'hello'
> > WAITFOR DELAY '00:00:7'
> > PRINT 'There'
> >
> >
> > With below:
> >
> > RAISERROR ('hello', 10, 1) WITH NOWAIT
> > WAITFOR DELAY '00:00:7'
> > PRINT 'There'
> >
> >
>
Hi Carl,
I understand your earlier reply: all your points make sense.
Tibor's suggestion is neat, I like it, I've filed it away for future use
myself. However, you do need to take careful note of his point "you need to
program asynchronously". You haven't said what technology you are using
(ADO.Net, ADO, DAO or whatever) but it shouldn't be hard to figure out how
to run a command or query asynchronously.
- Next message: David Portas: "Re: need help with procedure"
- Previous message: Roji. P. Thomas: "Re: need help with procedure"
- In reply to: Carl Imthurn: "Re: Returning intermediate results from a stored procedure"
- Next in thread: Tibor Karaszi: "Re: Returning intermediate results from a stored procedure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
