declare @sql varchar(1000)
set @sql='bcp.exe "Select * from demo.dbo.email" queryout D:/'+convert(char(10),getdate(),120)+'.txt -c -S(local) -Usa -P123456'
set @sql='bcp.exe "Select * from demo.dbo.email" queryout D:/'+convert(char(10),getdate(),120)+'.txt -c -S(local) -Usa -P123456'
EXEC master..xp_cmdshell @sql
bcp "select * from email where operate=5" queryout d:\email.csv -t "\t" -S "192.168.1.110" -d "demo" -U "sa" -P "12345678" -c