LISTING 1: Script to Copy a Text Field to an Ntext Field

-- create a table with an NTEXT column in pubs
USE pubs
CREATE TABLE mytextcol (c1 int not null, c2 ntext null)
GO
-- now create a long text field in pubs.
UPDATE pubs..pub_info set pr_info = 'THIS IS SOME REALLY LONG TEXT.
678901234567890THIS IS SOME REALLY LONG TEXT.    678901234567890THIS IS SOME
REALLY LONG TEXT.    678901234567890THIS IS SOME REALLY LONG TEXT.
678901234567890THIS IS SOME REALLY LONG TEXT.    678901234567890THIS IS SOME
REALLY LONG TEXT.    678901234567890THIS IS SOME REALLY LONG TEXT.
678901234567890THIS IS SOME REALLY LONG TEXT.    678901234567890THIS IS SOME
REALLY LONG TEXT.    678901234567890' [**Is this section of text supposed to 
be all wrapped around?** YES.]
WHERE pub_id = '0736'
GO
-- now copy the data
INSERT mytextcol SELECT CONVERT(int,pub_id), pr_info FROM pubs..pub_info
-- now read the data - looks fine to me...
SELECT * FROM mytextcol