April 14, 2008 at 12:36 am
Hi All
Currently I got a SQL Server 2000 and a database called XJ inside that there is a table called SD.
The issue I am facing currently is that inside the table called SD there is a column called Content which has a field value of 'LONG TEXT'.
I want to be able to view the content of this using the SQL analyser as well as be able to edit and update the information through it. IS it possible if so can someone help me with the coding. I am fairly a newbie to this.
Here is the table information.
Name Data Type Size Null
Content text 16 Ticked
Cheers 😎
April 14, 2008 at 7:26 am
You seem to have posted this in the wrong forum. This is for SQL 2005.
Regardless, there's no way to "edit" text data through Query Analyzer, so far as I know. You can use the various T-SQL commands for updating text data (textptr, updatetxt, writetxt), but it's not the same as editing them in a normal front-end application.
You're better off editing text fields in a normal front end. You can build one with .NET, or MS Access, or any number of other options.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply