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 - 2001-06-05 : 09:07:47
|
| Costin writes "I'm trying to use an SQL statement to create an html string, where it throws in all my variables in the right places. When I execute this, I get several rows. I can concatenate them into a variable by using SELECT @myvar = @myvar + 'text...', but that only goes up to 8000 characters, since SQL Server 7 doesn't allow me to define text variables as local variables. The ultimate goal, is to take my text string and store it in a column in one of my tables. So, does anyone have any suggestions on how to do this? Any help would be really appreciated. Thanks." |
|
|
|
|
|
Combining SELECT results into a text string