Will this really return list of primary key fields of a table?
>
>You can try
>
>select @@identity
>
>
>You should get the Autonumber field of the record you just inserted.
>
>It works for me in Vb.net using ado.net. I connect via oledb, not sure how relevant that is.