--exec master..xp_cmdshell 'bcp "SELECT * FROM [Gico.Management].[dbo].[tb_User]" queryout "c:/abc.xls" -c -S"192.168.0.2,11433" -U"sa" -P"123456"'
-- 下边那句话必须写成一行,换行就挂了,靠,我也不知道原因。
exec master..xp_cmdshell 'bcp "SELECT [CompanyName] ,[LinkManName] ,[LinkManPhone] ,[LinkManCellPhone],[InputDate],[RemarkInfo],[Address] FROM [Gico.Management].[dbo].[tb_CustomInfo] where userid=73 " queryout "c:/abc.xls" -c -S"192.168.0.2,11433" -U"sa" -P"123456"'