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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Who to view the data in text field?

Author  Topic 

noamway
Starting Member

7 Posts

Posted - 2005-10-16 : 12:32:31
Hello all,

I'm using the MSSQL version 8.
I build a new table with text data field.

After I insert some recoreds to this table, I'm trying to view them using SELECT sentence.

How can I view the data of this field?

Thanks!

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2005-10-16 : 12:54:27
I think you are trying retrive the data in enterprise manager. Execute the select sentence in Query analyser to view the data. But again if the data is too large then it won't be displayed.

Regards
Sachin Samuel
Go to Top of Page

noamway
Starting Member

7 Posts

Posted - 2005-10-16 : 18:54:10
So... What are you saying?!

I can't view this info and I can't update him?

There is no solution?

Thanks
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-17 : 00:47:26
>> I'm trying to view them using SELECT sentence.

Did you use Select textcolumn from yourTable?
If so what was the output?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -