>Hi, everybody!
>
>What is best way to retrieve NewID on a SQL Table:
> * Identity Fields?
> * A Meta-Table with the last ID generated for each one of my tables?
> * A SELECT MAX(ID) Statement?
>
> Or there's some other?
>
> I'm developing a N-Tier application and I'm using ADO RecordSets to pass data through layers...
>
> Any information about this issue is of extreme importance for me.
>
> Thanks in Advance!
Hi Claudio in my opinion the best is idetity fields in this way you don't have amy problem managing the id fields and after an insert if you need the id generated the do a SELECT @@IDENTITY to retrive the value of the id.
Alexandre Palma
Senior Application Architect