Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    Unanswered: insert into + varbinary

    i would like to insert a file into a table corresponding to a varbinary column. is there a way to specify the complete filepath in the local directory in the sql script? all within sql not c#.

    thanks in advance.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I can think of a what that makes it possible to put a file into a varbinary column using only the tools provided with Windows and SQL Server, but possible is still a very LONG way from being a good idea. I'd recommend storing the pathname in a VARCHAR. If you truly must store the file itself, I'd rethink the problem (at least three times) then I'd write a bit of code to do it.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts