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 appliestry thinking of NTEXT columns as the 'anchor' to your recordset.