把一个表的数据导入另一个表的问题

Question

insert into paymentdetail(mphonecode,username,feesumdeb,amount)
select mphonecode,username,0,feesumdeb)

Answer 1

--记录当前的最大 PaymentDetailID
declare @id int
select @id=max(PaymentDetailID) from PaymentDetail--插入数据
insert PaymentDetail(mphonecode,usrname,feesumdeb,amount)
select mphonecode,usrname,0,feesumdeb--把新增的 PaymentDetailID 记录到临时表
select PaymentDetailID into #t from PaymentDetail where PaymentDetailID>@id--显示新增的 PaymentDetailID 
select * from #t

Answer 2

i seeinsert into paymentdetail(mphonecode,username,feesumdeb,amount)
 select mphonecode,username,0,feesumdeb from TempArrearageList
那怎么把 把 PaymentDetailID 的值记录到一个临时表里？？？

Answer 3

insert into paymentdetail(mphonecode,username,feesumdeb,amount)
select mphonecode,username,0,feesumdeb)