Sunday, February 12, 2012

Anyway to set a primary key value

Hi just wondering if anyone knows if there is anyway to set a primary key
value? for example
pri key vharchar
1 paul
2 tom
999 Not Active
Can I somehow set the primary key for Not Active to 999?
thanks.
--
Paul G
Software engineer.Figured out a way around this one.
"Paul" wrote:
> Hi just wondering if anyone knows if there is anyway to set a primary key
> value? for example
> pri key vharchar
> 1 paul
> 2 tom
> 999 Not Active
> Can I somehow set the primary key for Not Active to 999?
> thanks.
> --
> Paul G
> Software engineer.|||If it is a one-time thing, take a look at IDENITY_INSERT
Rick Sawtell

No comments:

Post a Comment