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 |
|
mary_itohan
Posting Yak Master
191 Posts |
 Posted - 2008-08-20 : 18:16:33
|
| Hello,we have a list of number and emails in a database.We also run a .net script that sends our messages to the phone numbers and emails separately, based on batches and subscriptions.(in csv format)QUESTION:Whats the maximum length of a string that can be SAFELY be returned in a return value to the calling .net page ? from MS SQL serverie abc@yahoo.com,zxy@hotmail.com .... etc is an example 0121321321,0924254254 ..... is another examplethanksYes O ! |
|
|
PeterNeo
Constraint Violating Yak Guru
357 Posts |
Posted - 2008-08-21 : 02:16:25
|
| According to BOL, the maximum "Bytes per row" should not exceed 8060 bytes. |
 |
|
|
mary_itohan
Posting Yak Master
191 Posts |
Posted - 2008-08-21 : 07:40:27
|
| how long will this be ? 8,000 characters ?Yes O ! |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-08-21 : 08:25:37
|
| Depends.If the return string is an NVARCHAR it will take up 2 bytes per character.I believe there are also 2 bytes reserved for overhead.-------------Charlie |
|
|
|
|
|
|
maximum lenght for a return value