You could use:
select top1 * from table
You still get all the columns from the table but only one row (not
necessarily the first). If you just want a description of the result set
prior to to e.g. generating some sql, it may be better to use:
select * from table
where 1=0
This will minimise network traffic as the result set is empty
Regards.
----- Original Message -----
From: "Alexander Fedorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 4:31 PM
Subject: Re: Help: H0w to get frist row at SQl Server DB
> 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
___________________________________________________________________________
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
