Viewing 6 posts - 1 through 6 (of 6 total)
Try this link, seems to be doing what you want although admittedly I have not had a chance to test it. Syntax goes:
set cursor rows number for cursor_name
Link:
http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/51067;pt=51945
March 17, 2004 at 4:49 am
Iwould agree that the question is minimal and that the answer options act as clear guidelines as to what is expected. I am not sure I perceive that as a...
November 25, 2003 at 1:32 am
Yes, I made the same decision. Actually I had 4 ticked and then thought hang on... Shame about the answer it would have been a great trick question.
September 16, 2003 at 1:42 am
My deduction is that the query is assessing the contains condition on all columns seperately and accepting all results where any one column passes.
August 12, 2003 at 2:58 am
Amended original post to add permnum limitation.
declare @denom int
declare @num int
declare @aver float
declare myfetch cursor for select permnum, cola, colb, colc, cold from rmx
declare @myfetch nvarchar(10)
declare @myfetcha varchar(2)
declare @myfetchb varchar(2)
declare...
June 18, 2003 at 2:35 am
No real difference of opinion from me. I would send it back too primarily because it is sloppy irrespective of whether it is ever going to cause a problem.
June 3, 2003 at 2:07 am
Viewing 6 posts - 1 through 6 (of 6 total)