June 25, 2008 at 11:16 pm
Hi
How can I insert large amount of text data into ntext data field using query analyser.
Thanks
Salitta
June 26, 2008 at 7:32 am
Hi,
I think microsoft will remove ntext, text, and image data types in a future version of Microsoft SQL Server. So avoid using these data types in new development work, and plan to modify applications that currently use them.
You can use nvarchar(max), varchar(max), and varbinary(max) instead.
June 26, 2008 at 7:35 am
But You can add ntext, text, or image values to a row in the following ways:
1. Specify relatively short amounts of data in an INSERT statement in the same way char, nchar, or binary data is.
2. Use WRITETEXT
June 26, 2008 at 7:36 am
Syntax for WRITETEXT :
WRITETEXT { table.column text_ptr }
[ WITH LOG ] { data }
June 26, 2008 at 9:48 pm
Thank You Hari.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply