How to use the WRITETEXT command - newbie question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sunshine (nospam_at_yahoo.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 12:54:04 -0400

Hello all and please excuse me if I am in the wrong group.

I am very new to sql server and I am trying to update a ntext field. Of
course I realized I couldn't do a normal update statement and I found online
that I would have to do a WRITETEXT statement. However, I can't figure out
how to do this when I'm getting the data from another table. Here are my
tables:

table1
id int
desc ntext

table2
id int
desc ntext

I would like to update the data in table2 with the data in table1 where
table1.id = table2.id. Can you please help with this statement or direct me
somewhere that might have an example? I really appreciate your help!

Sunshine

Relevant Pages

  • Filtering and adding rows based on some condition
    ... DECLARE @TABLE1 TABLE ... (USGID INT NOT NULL,PCID INT NOT NULL) ... DECLARE @TABLE2 TABLE ... USGID PCID PCDESC Status ...
    (microsoft.public.sqlserver.programming)
  • Re: Text column copy across tables
    ... existing rows in TABLE1 using data present in the text column of a ... corresponding row in TABLE2. ... create table t(i int, t text) ... Don't forget to set textsize if datalength of the textfield ...
    (comp.databases.sybase)
  • Re: SQL Comparison of ISNULL values
    ... Can you show the exact results you want? ... ID INT, ... INSERT table1 SELECT 2, NULL ... INSERT table2 SELECT 3, NULL ...
    (microsoft.public.sqlserver.programming)
  • Re: Importing xml through tsql
    ... declare @h int ... --insert into table1 ... --insert into table2 ... > I want to upload xml data with sql's openxml. ...
    (microsoft.public.sqlserver.xml)
  • Re: ADP/SQL Data Selection Criteria in a Stored Procedure
    ... create table table1 (Client_Id int, DateEntered datetime, Employee_ID int) ... create table table2 ... > result in SP and return as a report row source in ADP. ...
    (microsoft.public.sqlserver.programming)