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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | AskSQLTeamAsk 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.ThanksKumar.SQL 2000 / Win2000 Server." |  |  
                                |  |  |  |