declare @OpenDate varchar(8)
SELECT @OpenDate=convert(varchar(8),dateadd(dd,-1,getdate()),112)
EXEC master..xp_cmdshell 'bcp EBILL_DLYH..TEMPEBILLDATA in E:\EBILLDATA_+@OpenDate+".txt" -t "" -r"" -c -S155.155.5.253 -Usa -Psa'请大家帮我看看我的这条语句有错误吗?
我觉得 E:\EBILLDATA_+@OpenDate+".txt" -t "" -r"" 这一部分可能有问题
SELECT @OpenDate=convert(varchar(8),dateadd(dd,-1,getdate()),112)
EXEC master..xp_cmdshell 'bcp EBILL_DLYH..TEMPEBILLDATA in E:\EBILLDATA_+@OpenDate+".txt" -t "" -r"" -c -S155.155.5.253 -Usa -Psa'请大家帮我看看我的这条语句有错误吗?
我觉得 E:\EBILLDATA_+@OpenDate+".txt" -t "" -r"" 这一部分可能有问题
EXEC master..xp_cmdshell 'bcp dbname..tablename in c:\DT.txt -c -Sservername -Usa -Ppassword' /** 导出文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename out c:\DT.txt -c -Sservername -Usa -Ppassword'
或
EXEC master..xp_cmdshell 'bcp "Select * from dbname..tablename" queryout c:\DT.txt -c -Sservername -Usa -Ppassword' 导出到TXT文本,用逗号分开
exec master..xp_cmdshell 'bcp "库名..表名" out "d:\tt.txt" -c -t ,-U sa -P password'
exec master..xp_cmdshell 'bcp "库名..表名" out "d:\tt.txt" -c -t ,-U sa -P password'
EXEC master..xp_cmdshell 'bcp dbname..tablename in c:\DT.txt -c -Sservername -Usa -Ppassword' /** 导出文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename out c:\DT.txt -c -Sservername -Usa -Ppassword'
或
EXEC master..xp_cmdshell 'bcp "Select * from dbname..tablename" queryout c:\DT.txt -c -Sservername -Usa -Ppassword'
SELECT @OpenDate=convert(varchar(8),dateadd(dd,-1,getdate()),112) EXEC master..xp_cmdshell 'bcp EBILL_DLYH..TEMPEBILLDATA in E:\EBILLDATA_+@OpenDate+".txt" -t -r"" -c -S155.155.5.253 -Usa -Psa' -t是信任连接,不用跟"" 分隔符吧。。
http://topic.csdn.net/u/20090828/13/b5155b6e-6935-444e-8395-0190656641e7.html
DECLARE @OpenDate VARCHAR(8)
SELECT @OpenDate = CONVERT(VARCHAR(8), DATEADD(dd, -1, GETDATE()), 112) SET @Sql='bcp EBILL_DLYH..TEMPEBILLDATA in E:\EBILLDATA_'+@OpenDate+'".txt" -t "" -r"" -c -S155.155.5.253 -Usa -Psa'
EXEC MASTER..xp_cmdshell @Sql