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 - 2006-06-16 : 08:43:48
|
| Manish B writes "Hi All,I need to use large amount of data in a SP. I have tried using Text DataType but it doesn't work. I get an error "Msg 2739, Level 16, State 1, Procedure a, Line 1The text, ntext, and image data types are invalid for local variables."any help will be appreciated.thanks & regardManish" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-16 : 09:01:28
|
| What do you mean by large amount of data?Do you want to use variable that can hold more than 8000 character?Search for 8000 in this topichttp://sqlteam.com/forums/topic.asp?TOPIC_ID=55210MadhivananFailing to plan is Planning to fail |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-16 : 11:06:16
|
| If you have SQL 2005, use varchar(max) or nvarchar(max).In SQL 2000, you can store the TEXT on NTEXT in a temp table, instead of a local variable.CODO ERGO SUM |
|
|
|
|
|
|
Large Data in SP