>How the statement would look like to preserve identity column?

insert into CreditInfo (< field list >) select * from CWebCreditLoad

Where, < field list > is a list of all columns excluding identity column in the same order as in SELECT column list.