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.