Hi Simon,
Thanks for your answer.
but through frontend, is there any way read all the data..
--create table table1 (test ntext)
insert into table1(test)
values (
'Tables are database objects that contain all the data in a database.
A table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
Tables are database objects that contain all the data in a database. A
table definition is a collection of columns. In tables, data is
organized in a row-and-column format similar to a spreadsheet. Each
row represents a unique record, and each column represents a field
within the record. For example, a table containing employee data for a
company can contain a row for each employee and columns representing
employee information such as employee number, name, address, job
title, and home phone number.
junk data.. up to 8KB'
)
select test from table1
------------------------------------------------------
if I use set TEXTSIZE 8000, still this not work,
is there any other way to select all the data.
(any help from READTEXT,UPDATETEXT,WRITETEXT) ?
"Simon Hayes" <sq*@hayes.ch> wrote in message news:<41**********@news.bluewin.ch>...
"Anand" <ve*************@yahoo.com> wrote in message
news:13*************************@posting.google.co m... If I insert 8000 byte of data, in the one of the column. now I want to
read the data, is there any to see all the data, through select
statement?
In Query Analyzer, go to Tools-Options-Results and set maximum characters
per column to 8000. If you're using a different client tool, then you might
need to do something similar (I don't think this is possible in EM).
Simon
