var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: BCP for xml
We have a table abc_xml which has def_xml col with varbinary in which we are storing .xml files
we use the below command to extact the .xml file using bcp
declare @cmd varchar(8000)
Set @cmd ='bcp "select cast(def_xml as varchar(2000)) from abc_xml" queryout d:\ppt.xml -t -w -r "" -S Abasha -U xxx -P xxx'
exec master..xp_cmdshell @cmd
we are able to genrate th xml file.
But when we try to open the .xml file in browser we are gettin the below error.
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.
Switch from current encoding to specified encoding not supported. Error processing resource 'file:///D:/ppt.xml'. Line 1, ...
<?xml version="1.0" encoding="utf-8"?>
Please suggest how to solve. or is there any way to solve this
Thnaks in advance