select No,Name,Sex,cast(IDCardNo as varchar(20)) as idcardno,InDate,Department,Salary,OtherSupply,Total,EatCost,
(case when b.fldCriterionI>=a.payroll then 0 else a.payroll-b.fldCriterionI end)*b.fldTaxRateR-b.fldDeductI as fldTaxR,
InsuranceCost,ManageCost,Roomcost,(Total-EatCost-InsuranceCost-ManageCost-roomcost)  AS Payroll,DateFrom,DateTo
into ##tempyanqun
from #temp3 a,tblTaxCriterion b
where (a.payroll>=b.fldIncomeFromI) and (a.payroll<b.fldIncomeToI) 
order by a.Noexec master..xp_cmdshell 'bcp ##tempyanqun out D:\book3.xls -c -q -S"it_yanqun" -U"sa" -P""'select * from ##tempyanqun
no                name             sex                       idcardno           ......
100004     黄志云     女          440923198612174063  
......
但是导出到excel时idcardno
440923198612174063 变成了 4.40923E+17