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 - 2002-04-30 : 09:19:14
|
| Enki writes "Hi,I'm trying to return a large string greater than 256 characters from a stored procedure. Is it possible to do this with a select statement? I know you can with an OUTPUT statement, but I need to use to select statement to return the value to a 3rd party programming language.Kind regards,Enki" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-30 : 09:33:47
|
| You can return large strings both through the OUTPUT parameters and as a SELECT statement. I just tried to return a 900 character string both ways and it worked fine (SQL7, SP3, NT4) |
 |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-04-30 : 10:39:27
|
| You didn't mention the platform you are using, if you are using SQL Server 6.5, then you are limited to 256. However, you can easily get around this by,SELECT @lstring1 + @lstring2 + @lstring3 + ....*************************Just trying to get things done |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-30 : 10:47:26
|
| The default 'Maximumn characters per column' setting for QA is 256, so if you are seeing truncation, it me be on the display layer . . .<O> |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-04-30 : 11:17:16
|
| I know I've run into a similar problem with Crystal reports. Any varchars over 255, you must cast as text.cast(myField as Text)Michael |
|
|
|
|
|
|
Returning large strings from stored procedures