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.