bcp "OrionNPM..nodestest"
EXEC master..xp_cmdshell 'bcp "OrionNPM..nodestest" in c:\nodes.txt -c -q -S"hostname" -Uzhou -P"zhou"'
注:nodes.txt文件是从另一台sql 2005库中通过bcp导出生成的文本文件。
//Microsoft SQL Server 2005 - 9.00.3042.00 BCP导数据时,出现如下错误:
开始复制...
SQLState = 22018, NativeError = 0
Error = [Microsoft][SQL Native Client]对于造型说明无效的字符值
SQLState = 22003, NativeError = 0
Error = [Microsoft][SQL Native Client]数值超出范围
SQLState = 22018, NativeError = 0
Error = [Microsoft][SQL Native Client]对于造型说明无效的字符值
SQLState = 22003, NativeError = 0
Error = [Microsoft][SQL Native Client]数值超出范围
SQLState = 22018, NativeError = 0
Error = [Microsoft][SQL Native Client]对于造型说明无效的字符值
SQLState = 22003, NativeError = 0
Error = [Microsoft][SQL Native Client]数值超出范围
SQLState = 22018, NativeError = 0
Error = [Microsoft][SQL Native Client]对于造型说明无效的字符值
SQLState = 22003, NativeError = 0
Error = [Microsoft][SQL Native Client]数值超出范围
SQLState = 22018, NativeError = 0