SQL Server Performance

Convert .sql to .txt - help

Discussion in 'Contribute Your Performance and Clustering Tips' started by bslapshot, Feb 9, 2005.

  1. bslapshot New Member

  2. Madhivanan Moderator

    The concept is to read from table and write it into the text file.

    exec xp_cmdshell 'bcp "select * from databaseName..TableName" queryout "D:fileName.txt" -c'

    Madhivanan

Share This Page