Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Reading text files in T-SQL

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2001-08-24 : 10:27:56
Kumar writes "I would like to set a variable equal to the contents of a text file (stored on the file system) in T-SQL. Can you help ?

The text file will contain an XML document.
I need to read the text file into a variable so that it can be passed to the sp_xml_preparedocument stored proc.
I can't figure out how to read a text file and assign the contents to a variable.


SQL 2000 / Win2000 Server.


- Advertisement -