look a example:
declare @str varchar(2000)
select @str='bcp "select a.au_lname,a.city,t.title,t.price from pubs.dbo.titleview as t left join pubs.dbo.authors as a on t.au_lname=a.au_lname" queryout c:\test.txt -Usa -Padmin -c '
exec master..xp_cmdshell @str,no_output
declare @str varchar(2000)
select @str='bcp "select a.au_lname,a.city,t.title,t.price from pubs.dbo.titleview as t left join pubs.dbo.authors as a on t.au_lname=a.au_lname" queryout c:\test.txt -Usa -Padmin -c '
exec master..xp_cmdshell @str,no_output
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货