Question:
I am in the process of creating an n-tier database application and am stuck at storing images to the SQL Server database. Any help would be appreciated.
Obviously, I need to read the image from the hard drive and store it to a variable (of what type?), and then pass it to my business layer, data access layer, and then the SP.
Answer:
The text datatype holds binary large objects, too, which is what you want to store. It’s done via the GETCHUNCK method in Visual Basic.