Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2015

    Unanswered: Store images in SQL Server 2008 R2

    i wanna ask, how to store images in SQL Server 2008 R2 through VB 2010 express edition?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The answer is the ever popular: It depends.

    For most cases, storing the file using the web server or a file share and storing the URL or UNC for that file is the easiest and most efficient way to handle them. You can store the bits in a VARBINARY(MAX) column and reconstitute the file as needed, but this is complicated compared to using the file system to handle the image files and storing the URL or UNC.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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