How toRetrive doc,pdf,xls files from SQL Server

[rudba]

Hello gus,

I have a database (sql server 2005) .
Data are store on table in binary data (doc, pdf, xls files)
How do i restore thoes files from SQL Server?

 

[jmcilhinney]

Binary data is saved and retrieved in exactly the same way as any other data. It gets transferred as a Byte array. You can write a Byte array to the file system by calling the File.WriteAllBytes method. ReadAllBytes will do the opposite.