sql server - BCP using xp_cmdshell to generate outputfile -
i'm using following generate output file xml content stored in image data type:
exec master..xp_cmdshell 'bcp "select xml mydatabase.dbo.mytable id = 1 " queryout "c:\temp\exportdir\myfile.xml" -t -s xyz\sqlexpress'
but following message: enter file storage type of field xml [image]
the file gets generated it's empty?
Comments
Post a Comment