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