Hello David,
Monday, April 09, 2001, 5:27:06 PM, you wrote:
ZD> HI, All
ZD> Help: H0w to get frist row at SQl Server DB
ZD> I have a huge table, but I only want to get the first row and I do not want
ZD> use
ZD> select * from Table to get WHOLE thing.
ZD> Thnaks a lot in advance!
* means - all fields from the row, pal.
u have to use this query, and get ONLY one line from resultset.
Let the power be with you.
ZD> ___________________________________________________________________________
ZD> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
ZD> of the message "signoff SERVLET-INTEREST".
ZD> Archives: http://archives.java.sun.com/archives/servlet-interest.html
ZD> Resources: http://java.sun.com/products/servlet/external-resources.html
ZD> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
--
Alexander Fedorov
Software developer
Adcore
Wibautstraat 120
1091 GP Amsterdam
the Netherlands
tel: +31 (0)20 561 1825
fax: +31 (0)20 5611701 or +31 (0)20 5611849
e-mail: mailto:[EMAIL PROTECTED]
www.adcore.nl
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6
mQEPAzp+jaIAAAEIAKB37EITxsVevyCDd9hOmtLhyzncJZ94UIhi/yflAk8c3xr+
1lFkXpXrs7PhmzTzzojmJQulUIBwV8IHVi3P3sua4PpcRWtAzbGfP4G4rsGcBKdi
09xkELSEtfICsBU3/haQQIB2UH/T/zAefFaRj3XRI/Mqwhz1v6uqwy3zWtKpJWVE
RpeA6ShMd+w7Gp5NvsomUjEpZRIZLWBHpcbjsn34A1VLUMw272e2o9ndV91nDcFf
SFZQpNCUdhM7eM9x4ab6pIrLkWlvDehQnBAyXs95Zxviwhmd37fBWM4MA3V9GsLv
ZxJ1WmmPyu4Hv/7tTYNDSlODHYU5jIZg+jBbvJUAEQEAAbQwQWxleGFuZGVyIEZl
ZG9yb3YgPGFsZXhhbmRlci5mZWRvcm92QGFkY29yZS5jb20+
=Ak1z
-----END PGP PUBLIC KEY BLOCK-----
___________________________________________________________________________
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