Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shahidras
Starting Member
2 Posts |
 Posted - 2009-06-29 : 01:25:57
|
| in my store procedure i have a varchar(max) variable and after some calculations i store all data in it and i want to email data to users. some problem is that data is too large to store in varchar(max) so not all data store in variable, when variable is fill, all remaining data is lost, please tell me how to do that things |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-29 : 01:37:56
|
varchar(max) can hold 2^31-1 bytes (2,147,483,647).I don't believe you want to email that  Fred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
shahidras
Starting Member
2 Posts |
Posted - 2009-06-29 : 09:48:21
|
| thanks for your reply.my problem is solved |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-29 : 10:00:50
|
What is the data made of?You can make an automatic attachment of a stored procedure or query result. You can even name the attached file the way you want.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
how to store large data in sql variable