[Solved] How to import JPEG file in MS SQL server? [closed]

Question

You probably want to use the binary, varbinary or varbinary(max) data type.

Of course, you have to convert the (JPEG) image to a byte array first in order to store it in the database. Depending on the programming language of your choice this can be easy or hard.
Not sure if you can read files from a T-SQL command and store/retrieve them from a database. Then again, I don’t think you would want such a scenario in real-life.

Accepted Answer

You probably want to use the binary, varbinary or varbinary(max) data type.

Of course, you have to convert the (JPEG) image to a byte array first in order to store it in the database. Depending on the programming language of your choice this can be easy or hard.
Not sure if you can read files from a T-SQL command and store/retrieve them from a database. Then again, I don’t think you would want such a scenario in real-life.