create a new column that is 1000 less than orderid column

rgb192
rgb192 used Ask the Experts™
on
I dont want this to be a computed column
i want it to be a permanent column
no need to update column for new orders
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012

Commented:
Then your only choice is to resort to using a TRIGGER.

Author

Commented:
how
Commented:
if you don't need to update the column for new records you may simply add a new column and fill it with

update tablename set newOrderId = orderid-1000

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial