Autonumbered field/datatype in SQL

<i><b>Originally posted by : Filip (Filip.wilsens@pandora.be)</b></i><br />Is there a sort of autonumbered field in SQL like there is in Access? Or a special query-statement from which I can see how many entries I have in my databasetable?<br /><br />Ex:<br />Database: MyData<br />Table: MyTable<br /><br />How do I make an ASP-page (statements) from where I can query this devices and display just one entry of the whole table (ex. "Name") which implifies URLs who link to the complete entry (Name, Mail, ICQ, ...)! Not the whole table, just one full entry from the table!<br /><br />I can't get this to work with the standard frontpage-statements!<br /><br />Thx in advance,<br />Filip.

<i><b>Originally posted by : </b></i><br /><br /><br /><br />------------<br />Filip at 9/13/2000 2:45:32 AM<br /><br />Is there a sort of autonumbered field in SQL like there is in Access? Or a special query-statement from which I can see how many entries I have in my databasetable?<br /><br />Ex:<br />Database: MyData<br />Table: MyTable<br /><br />How do I make an ASP-page (statements) from where I can query this devices and display just one entry of the whole table (ex. "Name") which implifies URLs who link to the complete entry (Name, Mail, ICQ, ...)! Not the whole table, just one full entry from the table!<br /><br />I can't get this to work with the standard frontpage-statements!<br /><br />Thx in advance,<br />Filip.