Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Since SQL ban user from creating a variable of type text, is there any way to store more than 8000 characters in a local variable within
a stored procedure?
I'm trying to build an HTML body to be send via email to vendors.
The HTML body is dynamic depending on the number of vendor's invoices.
The HTML body along with the vendor's email address will be passed to a stored procedure (SP_SendSmtpMail) to send the message (The HTML body parameter in the stored procedure is defined as text).
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