Posted by laurenq uantrell on 10/20/89 11:27

Erland,
Thanks for your reply.

> @Col3Data ntext = Null,
>...
> 'Text Label: ' +
> isnull(Cast(@Col3Data AS nvarchar(4000)),'<none>')
>...

>What's the point with accepting an ntext parameter, if you truncate it anyway?

The second table is used to hold a history of changes to the first
table tblStuff and in this particular case it's not necessary (or
desirable) to have the unlimited text in any ntext column stored, so
it's truncated.

[Back to original message]