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 2005 Forums  Transact-SQL (2005)  How to load entire file into 1 record

Author  Topic  sw26p2 Starting Member 8 Posts Posted - 2009-09-23 : 07:52:47 I have a table containing the columns: - FileName varchar(200) - FileContent text I need to write a stored procedure that will open the file in FileName and load the entire contents of the file into the FileContent column. Is there a way to access the File on the drive, and have it do a "read all" to get entire file? Thanks for your help.