February 10, 2007 at 4:29 pm
I have forgotten how to do this...duh! I would like the output of a sproc to be immediate instead of buffered like it seems to be now. What is the set option for this?
--Frank
February 11, 2007 at 6:20 am
I havent't used this one, but there is an option-clause for the select statement
USE pubs
SELECT a.au_fname, a.au_lname, SUBSTRING(t.title, 1, 15)
FROM authors a INNER JOIN titleauthor ta
ON a.au_id = ta.au_id INNER JOIN titles t
ON t.title_id = ta.title_id
GROUP BY a.au_lname, a.au_fname, t.title
ORDER BY au_lname ASC, au_fname ASC
OPTION (FAST 10)
February 12, 2007 at 8:47 am
Try:
RaisError() with NoWait
... and don't foget to escape any '%' in your output string...
February 12, 2007 at 5:42 pm
Peter,
That RAISERROR might do the trick. Excellent suggestion...DUH , I should have thought of that!
--Frank
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply