Tag Archives: bcp queryout pipe delimiter

export select query result in to pipe delimiter Textfile

Hello Friends, I have a table that I need to export to a pipe delimited .txt file.please follow the below step to do that things. Steps 1: [https://amitpatriwala.wordpress.com/2010/04/02/save-select-query-result-into-textfile/] Enabled the xp_cmdshell By default disabled in SQL 2005 for security reasons. To enable it, use the Surface Area Configuration tool or sp_configure To enable xp_cmdshell using […]