Last 10 inserted records

[Grudge]

Hey There,

is there a way to determine which we're the last x rows inserted into the sql table, without using some kind of reference field (datetime, etc.) ?

Thanks for you help

 

[fluteplr]

No

 

[tlbroadbent]

To elaborate, LAST and FIRST are not relational concepts. By definition, SQL record sets are unordered. SQL Server does not guarantee order of result sets returned by queries unless the Order By clause is used. Thus the only way to get FIRST or LAST rows is to use an order indicator such as an identity column or datetime.

Tables are ordered physically by a clustered index and my experience has been that simple selects from a single table without an order by clause will return results in the sequence of the clustered index, if one exists on the table. However, Microsoft makes no guaranteee that this will always be the case. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.