H‌ow to save Word file as varbinary data into SQL server?

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  October 30, 2018 at 5:21 am

  #372635

  For security reason, some Word files (DOC/DOCX) can't save into file server.
  How to save them as varbinary data into SQL server?

• Jeff Moden

  SSC Guru

  Points: 1004561

  More actions

  October 30, 2018 at 6:28 am

  #2011663

  adonetok - Tuesday, October 30, 2018 5:21 AM

  For security reason, some Word files (DOC/DOCX) can't save into file server.
  How to save them as varbinary data into SQL server?

  It would help if you told us how you're currently trying to save them.  I'm also pretty sure that folks will recommend using something like File Stream instead of actually storing them in a database.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)