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
(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
有没有试过把Excel里面这个字段选死为文本类型再bcp啊?