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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-13 : 10:53:50
|
| Prabhu writes "Hello,I am devloping a application in SQL Server which selects the name and emailid of all persons in the database whose birthday is today and send the remainder to others.To Concat all the names and emailid i have declared a variable of size 8000.I fear that is the records returned is large then this will create me a problem.I need a datatype similar to one of type text which supports upto 2 GBPlz help me..RegardsPrabhu.S" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-13 : 12:35:18
|
| You said that you need a data type similar to text, but why not just use text then? There isn't any other data type similar except for ntext. BTW, why would you want to concat all the names and emailids into one variable? That doesn't sound like a good idea at all.Tara |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-06-13 : 12:51:11
|
quote:
and send the remainder to others.
Please Clarify, You wish to send a list of names and e-mail addr. for everyone who does not have a birthday today?Or are you trying to e-mail everyone about someones birthday excluding themselves?JimUsers <> Logic |
|
|
|
|
|
|
Declaring String variables of Size greater than 8000