Tuesday, 13 August 2013

SQL Server : read full ntext column value

SQL Server : read full ntext column value

I have aspnet_Tablename. kindly see below pic for data design.

Now, here on PropertyValuesString column, data is storing as a xml format.
When I run this query.
SELECT TOP 10 [PropertyValuesString] FROM Table
I am getting results, but not the whole record of PropertyValuesString
column.
So, any one let me know. how can i get whole value of an ntext property
column?
Also tried with
select top 10 (max (convert(nvarchar(4000), PropertyValuesString))) FROM
Table
But no luck.
Thanks

No comments:

Post a Comment