Information générale
Forum:
Microsoft SQL Server
Titre:
Send email and attach different files
I want to send a email and attach different files each day.
For example, today will attach file named Reponse20041012.txt. Tomorrow will another file Reponse20041013.txt.
I have following code. It didn't work. I feel some confused where to use ' and ".
DECLARE @cmd varchar(200)
Declare @Response varchar(50)
set @Response= 'Response'+CONVERT(char(8), getdate(), 112)+'.txt'
set @cmd = 'master..xp_sendmail @recipients = "JimHou",'
+'@subject = "Response Report",'
+'@attachments = "N:\DATA\"'+@Response
EXEC @cmd
Thanks
Jim
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement