SQL Server Performance Forum – Threads Archive

Modifying Text data

Hi, I have one question. How can i read and modified Text data type using query analyzer. thanks and Regards Ravi K

---

Create table a (b text)
insert into a values (‘aaaaaaaaa33aa’)
insert into a values (‘aaaaaaaaa22aa’)
insert into a values (‘aaaaaaaaa22aa’)
insert into a values (‘aaaaaaaaa12aa’)
insert into a values (‘aaaaaaaaa12aa’)
select * from a
it is same as other data type..

---

Have a look at READTEXT, WRITETEXT and UPDATETEXT in BOL. And see if this helps:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

---

]]>