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.If it is a one-time thing, take a look at IDENITY_INSERT
Rick Sawtell

No comments:

Post a Comment