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

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -