Creating FILE using T-SQL

• KV-400470

  SSC Rookie

  Points: 37

  More actions

  February 2, 2007 at 2:49 am

  #194134

  Can any one help me about text files creating using in the t-sql.

  provide me any script or articals regarding this.

   

  thanks in advance

  Kalai

  ---

  Kindest Regards,

  Kalai

• Damian Widera-396333

  Ten Centuries

  Points: 1196

  More actions

  February 2, 2007 at 3:12 am

  #687340

  Hello

  The following example writes the contents of the @var variable to a file named var_out.txt in the current server directory:

  DECLARE @cmd sysname, @var sysname

  SET @var = 'Hello world'

  SET @cmd = 'echo ' + @var + ' > var_out.txt'

  EXEC master..xp_cmdshell @cmd

  Assumptions:

  1) this requires, that you  have rights to run xp_... procedures  -sysadmin role

  2) you must enable xp_... to be called :

  sp_configure

  'Show advanced options','1'

  go

  RECONFIGURE

  go

  sp_configure

  'xp_cmdshell', '1'

  go

  RECONFIGURE

  go

  Kindest Regards,

  Damian Widera
  SQL Server MVP,
  MCT, MCSE Data Platform, MCSD.NET