469,277 Members | 1,923 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,277 developers. It's quick & easy.

Update a column

374 256MB

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.

Aug 13 '10 #1
2 886
32,172 Expert Mod 16PB
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.
Aug 13 '10 #2
2,878 Expert 2GB
If JobID should always be related to the incremented column, just use a COMPUTED COLUMN instead.

Good Luck!!!

~~ CK
Aug 13 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by logina1 | last post: by
2 posts views Thread by Thomas609 | last post: by
3 posts views Thread by =?Utf-8?B?Um9nZXIgVHJhbmNoZXo=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.