Question

我正试图从表格中撰写一份产出文件。我没有发现任何错误,但档案没有制作。

 EXEC master..xp_cmdshell  bcp "SELECT * FROM DB.dbo.table1" queryout "C:employee.txt" -T -Sservername -U user111 -P pwd -c -t,

我不清楚为什么没有立案。谁能帮助?

I am not getting errors instead I get following messages:

usage: bcp {dbtable | query} {in | out | queryout | format} datafile
 [-m maxerrors]            [-f formatfile]          [-e errfile]
 [-n native type]          [-c character type]      [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
  [-C code page specifier]  [-t field terminator]    [-r row terminator]



[-i inputfile]            [-o outfile]             [-a packetsize]

[-S server name]          [-U username]            [-P password]
[-T trusted connection]   [-v version]             [-R regional enable]
[-k keep null values]     [-E keep identity values]
  NULL

我在服务器A上运行,但数据库在服务器B上,例如服务器A I SERVER管理演播室,并给服务器B细节登录。在我提出上述问题之后,我提出了问题。因此,将建立哪一个服务器?

Answer 1

问题正确:

EXEC master..xp_cmdshell  bcp "SELECT * FROM DB.dbo.table1" queryout "C:employee.txt"

- 服务器名称——Uuser111 -P pwd -c -t

while typing in SQL SERVER MANAGEMENT studio I pressed enter after queryout so statement "C:employee.txt" - 服务器名称——Uuser111 -P pwd -c -t was coming in next line. because of this I was not getting any error or

Answer 2

甚至在用户名和通行证之后,就与我合作或没有空间。您是否可读到C:在服务器箱上? 如果你也使用——T?

Answer 3

http://msdn.microsoft.com/en-us/library/ms162802.aspx” rel=“nofollow noreferer”题目=“bcp Utility” MSDN:

<>安全说明>

当bcp公用事业与服务器连接时,使用-T选项(连接<>><>><>>><>>而不是<>>>。 user name and passwordjoint.

友情链接