Using SELECT * on a Table with the Column Type NTEXT

If you use SELECT * on a table with the column type NTEXT, your resultset will not display the NTEXT column on a Web page when using ASP to show the recordset.

To ensure that the NTEXT contents display, move the NTEXT column to the last column in your recordset. If you are pulling data from a view, the same thing applies?try thinking of NTEXT columns as the ‘anchor’ to your recordset.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: