Use Statement method "setMaxRows(1)" for the Statement object before you execute
the query.
"Zhang, David" <[EMAIL PROTECTED]> on 04/09/2001 10:27:06 AM
Please respond to "A mailing list for discussion about Sun Microsystem's Java
Servlet API Technology." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Harvey A Smith/MSD/US/PBI)
Subject: Help: H0w to get frist row at SQl Server DB
HI, All
Help: H0w to get frist row at SQl Server DB
I have a huge table, but I only want to get the first row and I do not want
use
select * from Table to get WHOLE thing.
Thnaks a lot in advance!
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
