How can I read the contents of a file ?

• rechousa

  SSC Veteran

  Points: 215

  More actions

  August 30, 2002 at 10:39 am

  #78862

  Hi !

  I would like to read the contents of a file, using SQL SERVER ?

  How can I do this ?

  Thanks,

  PM

  Rechousa,

  V.N.Gaia

  Portugal

  
  Rechousa,
  V.N.Gaia
  Portugal

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736468

  More actions

  August 30, 2002 at 11:12 am

  #435754

  A text file?

  xp_cmdshell 'type filename.txt'

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones