Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
T-SQL: how manage TEXT field????
<b>Both UPDATETEXT AND WRITTEXT make only an update on the field you give them by a pointer </b>.....<br><br>I have to read from a field A1<br>and then write it to the field A2......<br><br>and i remeber that field A has datatype TEXT<br>My problem is that you can't do:<br><br>SELECT A FROM...- daniela
- Post #5
- Forum: Microsoft SQL Server: Programming
-
T-SQL: how manage TEXT field????
Thank for your reply .............<br><br>but it is not possible an Update if you have to manage a field which data type is TEXT....<br><b>AT LEAST with MS SQL SERVER (7.0) IT' S NOT POSSIBLE<br>I'M AFRAID </b><br><br>I've already tried what suggested me but the response...- daniela
- Post #3
- Forum: Microsoft SQL Server: Programming
-
T-SQL: how manage TEXT field????
I work on SQL SERVER 7.0 <br>with T-SQL I have to read a TEXT field <br>and write it into a new record, but..... <br>What happen is: <br><br>DECLARE @ptr1 varbinary(16), @ptr2 varbinary(16) <br><br>SELECT @ptr1 = TEXTPTR(DESCRIPTION) <br>FROM tableA <br>WHERE ID =...- daniela
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
