469,641 Members | 1,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,641 developers. It's quick & easy.

ntext

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?
Jul 20 '05 #1
3 2433

"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
Jul 20 '05 #2
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

Jul 20 '05 #3
You can use SET TEXTSIZE so that a normal SELECT can return over 4KB to your
app:

SET TEXTSIZE 32768
SELECT test FROM Table1

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Anand" <ve*************@yahoo.com> wrote in message
news:13**************************@posting.google.c om...
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

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Derek Erb | last post: by
2 posts views Thread by Sileesh | last post: by
3 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.