Re: fetch row or fetchall

You could use TOP.

Select TOP 100 * from table
[download]

Rupesh.

Comment on Re: fetch row or fetchall Download Code

Replies are listed 'Best First'.
Re^2: fetch row or fetchall by jfroebe (Parson) on Nov 10, 2004 at 05:04 UTC
TOP is not ANSI standard SQL... meaning that its use is limited to those dbms's that have this extension. Team Sybase member No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1	[reply]