更新NTEXT的方法

declare

@id numeric ( 18 , 0 )

DECLARE

ResultSet_News CURSOR FOR

SELECT

Id FROM product_ta_product ;

OPEN

ResultSet_News ;

FETCH

NEXT FROM ResultSet_News into @Id

WHILE

@@FETCH_STATUS = 0

BEGIN

print @id

DECLARE

@CommentVar nvarchar ( 4000 );

-- Read in existing comments from COMMENTS column in view named MyView

SELECT

@CommentVar = product_description FROM product_ta_product WHERE id = @id ;

-- Insert text a top of comment (example is a running history with most recent first)

SET

@CommentVar = replace ( @CommentVar , 'http://www.4wdcc.com/admin' , 'http://www.leods.com/admin' );

-- Now go update the field

UPDATE

product_ta_product SET product_description = @CommentVar WHERE id = @id ;

 

FETCH NEXT FROM ResultSet_News into @Id

END ;

CLOSE

ResultSet_News ;

DEALLOCATE

ResultSet_News ;

转载于:https://www.cnblogs.com/miaomiaoga/archive/2006/07/31/463858.html