Subject | Return PK Value |
---|---|
Author | John W. (Jack) Cane |
Post date | 2013-08-23T04:34:01Z |
I would like to learn the primary key value of successful SQL Insert command. The following syntax was picked up from (I think) a reliable source, cannot recall where. It generates an error at 'Output'. Could you please show me the correct syntax.
'Insert into table( column set ) Values(value set)' Output inserted.pkImage
Best,
jwc
from iMac
[Non-text portions of this message have been removed]
'Insert into table( column set ) Values(value set)' Output inserted.pkImage
Best,
jwc
from iMac
[Non-text portions of this message have been removed]