Is there a not-so-obvious way to get around the varchar(8000) limition for variables in stored procs?
Specifically I send automated emails and faxes directly in sql server by scheduled jobs that call procs. And I build up the string for the email in the proc and if the string exceeds the varchar size it will blow.
I know I could write a C# exe or some shit to do this but would prefer it to just live in the database if I could. When is Yukon going to be released?
Specifically I send automated emails and faxes directly in sql server by scheduled jobs that call procs. And I build up the string for the email in the proc and if the string exceeds the varchar size it will blow.
I know I could write a C# exe or some shit to do this but would prefer it to just live in the database if I could. When is Yukon going to be released?
