try: exec master..xp_cmdshell 'bcp "select ID,cCustNo,cCustName,nMoney from table union select '记录数:',cast(count(*) as char) as cCustNo,'合计:',sum(nMoney) as nMoney from table" out newpubs.dat -c -t | -r \n -Sservername -Usa -Ppassword'
哈哈: 谢了 我试了-t 后面加 '|' 提示错误.改用分号或逗号都可以.
蚂蚁 : 用DTS具体怎么实现?有代码吗?本人急用?
Master..Xp_CmdShell 'bcp "Select ID+''|''+cCustNo+''|''+cCustName+''|''+Cast(nMoney as VarChar(10)) From DataBaseName..TableName Select ''记录数=''+Cast(Count(*) as VarChar(4)),Cast(Sum(nMoney) as VarChar(10)) From DataBaseName..TableName" queryout D:\Out.txt -w -S aa -U sa -P'
如果不用导入可以应付了: exec master..xp_cmdshell 'bcp "Select ID+''|''+cCustNo+''|''+cCustName+''|''+Cast(nMoney as VarChar(10)) From DataBaseName..TableName union select ''记录数:''+cast(count(*) as char(4))+''合计:''+Cast(sum(nMoney) as Char(10)) from DataBaseName..TableName" queryout D:\Authors.txt -w -S aa -U sa -P '
run below in dos prompt:bcp pubs..sales out c:\sales.txt -c -t"|" -r"\n" -Sservername -Usa -P
exec master..xp_cmdshell 'bcp "select ID,cCustNo,cCustName,nMoney from table union select '记录数:',cast(count(*) as char) as cCustNo,'合计:',sum(nMoney) as nMoney from table" out newpubs.dat -c -t | -r \n -Sservername -Usa -Ppassword'
谢了
我试了-t 后面加 '|' 提示错误.改用分号或逗号都可以.
蚂蚁 :
用DTS具体怎么实现?有代码吗?本人急用?
Master..Xp_CmdShell 'bcp "Select ID+''|''+cCustNo+''|''+cCustName+''|''+Cast(nMoney as VarChar(10)) From DataBaseName..TableName Select ''记录数=''+Cast(Count(*) as VarChar(4)),Cast(Sum(nMoney) as VarChar(10)) From DataBaseName..TableName" queryout D:\Out.txt -w -S aa -U sa -P'
exec master..xp_cmdshell 'bcp "Select ID+''|''+cCustNo+''|''+cCustName+''|''+Cast(nMoney as VarChar(10)) From DataBaseName..TableName union select ''记录数:''+cast(count(*) as char(4))+''合计:''+Cast(sum(nMoney) as Char(10)) from DataBaseName..TableName" queryout D:\Authors.txt -w -S aa -U sa -P '
bcp pubs..sales out c:\sales.txt -c -t"|" -r"\n" -S"servername" -U"sa" -P""