How to Store and view a Image in database using sql....?

Question

Hi...Sir/Madam

I Want to store the image in my database...

I gave a sql query to create a table 

"Create Table EmployeeProfile ( EmpId int, EmpName varchar(50) not null, EmpPhoto varbinary(max) not null )"

After, creating the table.. I gave a insert query like this..

"Insert EmployeeProfile (EmpId, EmpName, EmpPhoto) Select 1001, 'Vadivel', BulkColumn from Openrowset( Bulk 'C:\Users\Public\Pictures\Sample Pictures\Koala.jpg', Single_Blob) as EmployeePicture"

Am getting the result...but am not able to view the image stored in database...

So Please Help me....

---

BaluJagua

Answer 1

hello,

 you can use SSIS or SQL to accomplish this...Please se the below links http://www.sqlusa.com/bestpractices/imageimportexport/

http://www.mssqltips.com/sqlservertip/2693/export-images-from-a-sql-server-table-to-a-folder-with-ssis/

You can also view it from the table,if you have ssms boost pulgin.. please see this thread http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/43c3741e-4c30-4aad-9b8e-23ebc4fde07d

---

Please mark as 'Answer', if the solution solves your problem.

Answer 2

Am getting the result...but am not able to view the image stored in database...

You wont be able to view the image stored in the database column , it will be in binary format. You may have to use the front end application to view it.

Regards
Satheesh