Writing to a file from T-Sql

• petey20

  SSCommitted

  Points: 1741

  More actions

  April 1, 2002 at 10:05 am

  #158182

  Are there any procedures that allow you to write to a file in T-sql?

  Like say, pass in a string and a fully qualified path to a file ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  April 1, 2002 at 10:38 am

  #426363

  there is Bulk Copy.

  You can also use xp_cmdshell and isql to do this. Use the -Q and -o options with isql.

  Steve Jones

  steve@dkranch.net