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 - 2005-01-17 : 09:52:26
|
| Tracy writes "I am trying to extract data from a text field where the data stored in the field is over 16K. I have already looked at using READTEXT but I am limited to 16K with Query Analyzer. I can get the data by creating a .Net application and pulling it out. Is there a way to do this with a built-in SQL tool using only T-SQL? I am using SQL Server 2000 Developer Edition (.818) on a Windows 2000 Server." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-01-18 : 19:53:39
|
| Once you have "pulled it out" what do you want to do with it? Just view it on screen?---------------------------------------------------------------------------------Infoneering: Information Technology solutions engineered to professional standards. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-01-18 : 21:06:28
|
quote:
Once you have "pulled it out" what do you want to do with it? Just view it on screen?
Please, no pr0n webcams on SQL Team. Thanks. |
|
|
|
thuscroft
Starting Member
1 Post |
Posted - 2005-01-20 : 15:55:10
|
| Yes. I just want to view it. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-01-21 : 14:31:21
|
| Hmmm... Well, 16K is about what... 8 pages of printed text? I don't think QA will be of much help here. If you really want to view it, then your .NET app is probably as good of a solution as any.---------------------------------------------------------------------------------Infoneering: Information Technology solutions engineered to professional standards. |
|
|
|
|
|
|
Retrieving data from a TEXT field where the data stored is over 16K