If I have a table with the primary key set to auto-increment and I just wrote a record to that table... how can I query and get the key?

Sandy

select @@identity or select scope_identity()

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/