Please start any new threads on our new site at https://forums.sqlteam.com. 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 

AskSQLTeam
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.


Thanks
Kumar.

SQL 2000 / Win2000 Server.


"
   

- Advertisement -