110,499
社区成员
发帖
与我相关
我的任务
分享
cmd.CommandText = "EXEC master..xp_cmdshell " + "\' " + "BCP" + " \"" + "select * from 信号采集.dbo.Save_Download" + "\"" + " queryout " + filePath + " -c -q " + "-U " + "\"" + U + "\"" + " -P " + "\"" + P + "\"" + "\'";
cmd.ExecuteNonQuery();
EXEC sp_configure 'show advanced options', 1
GO--
RECONFIGURE
Go
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
Go
EXEC master..xp_cmdshell'bcp 信号采集.dbo.Sava_Download out C:\temp.xls -c -q -S"localhost" -U"qsy" -P""'