Stephen,
>I wanted to view all the records in a table in the order that they were created in ? can you think of any way of doing this ?
Add a datetime-type field and populate it when adding records with the SQL Server GetDate() function. (You might think you could add the SQL Server Timestamp (auto-populated) field, but it gets changed every time the record is updated.)
Of course, if the data is already in the table, this idea won't help you. Bottom line is that you cannot count on SQL Server preserving any kind of record order, although it might look like that is the case when looking at the data via Query Analyzer.