declare @cmd varchar(1000)
set @cmd='bcp "select top 100 * from data_02..oeprcfil_sql where filler_0001 like ''ahyy%''" queryout "d:\test.xls" -c -S"server-1" -U"sa" -P"macola"'
EXEC master..xp_cmdshell @cmd
set @cmd='bcp "select top 100 * from data_02..oeprcfil_sql where filler_0001 like ''ahyy%''" queryout "d:\test.xls" -c -S"server-1" -U"sa" -P"macola"'
EXEC master..xp_cmdshell @cmd
like 'ahyy%'这里不能用但引号!!!
set @cmd='bcp "select top 100 * from data_02..oeprcfil_sql where filler_0001 like ''ahyy%''" queryout d:\test.xls -c -Sserver-1 -Usa -Pmacola'
EXEC master..xp_cmdshell @cmd