Update a column

[OuTCasT]

Hi

Is it possible to update a columns data in a row to another columns data when that row is inserted ?
For example i have a incremented column and i want to set the Job ID column equal to the incremented column when the row is inserted.

so each row will have the incremented value and the same value of that column in the jobid column of the same row.

Thanks

[NeoPa]

I imagine that would depend on how you are inserting the data. It's hard to help with questions when only half the necessary information is available.

[ck9663]

If JobID should always be related to the incremented column, just use a COMPUTED COLUMN instead.

Good Luck!!!

~~ CK