SQL Server 2005 BCP工具导入时间项不准确
- SQL code
EXEC master..xp_cmdshell 'BCP esky_test.dbo.Table_esky2 in D:\Bruce\Server\Server\UDPServer\Currency.dat -e D:\Bruce\Server\Server\UDPServer\err.txt -x -c -T\'
Currency.dat文件中的内容（这个一个文本文件）[b][/b]
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.504171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.504
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.505171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.505
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.507171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.507
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.509171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.509
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.510171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.510
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.512171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.512
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.513171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.513
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.515171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.515
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.516171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.516
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.518171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.518
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.519171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.519
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.521171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.521
写入到SQL Server中的数据
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.503171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.503
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.507171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.507
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.507171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.507
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.510171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.510
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.510171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.510
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.513171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.513
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.513171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.513
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.517171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.517
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.517171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.517
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.517171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.517
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.520171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.520
86543900011606031.28985120.601220 KM/H2012-03-12 21:20:55.520171.081111111111110x11111127.0.0.1:1662112012-03-12 21:19:55.520
请注意数据库中日期时间的那两项和Currency.dat文件中的差别：文件中2012-03-12 21:20:55.504写入数据库后变为2012-03-12 21:20:55.503，最后一项的毫秒变了，各位大侠，这个是为什么呢？这一项对我挺重要的，如果写成一样的话，我读出来就会有问题。[b][/b]
------解决方案--------------------
最后一项的毫秒在sql server中不是一个精确数据.所以无法保证你数据的准确行.
[解决办法]