Viewing 4 posts - 1 through 4 (of 4 total)
I am getting
Col
----
<?xml version="1.0" encoding="UTF-8"?><asdf>woot</asdf> in a string when I am trying to convert it into XML like select CONVERT(XML,'<?xml version="1.0" encoding="UTF-8"?>' + cast(@xml as varchar(max)))
Getting only
<asdf>woot</asdf>
What...
January 22, 2014 at 10:15 am
#1682508
getting with your query like
(No column name)
But I need like
<?xml version="1.0" encoding="UTF-8"?>
January 22, 2014 at 10:03 am
#1682502
For Exp: I have the row data lengthy like "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa"
I need to display that data in Card in Power View, I able display as it is
but I need like...
April 8, 2013 at 5:38 pm
#1604614
#1604613