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

  • 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....


    • Changed type Kalman Toth Thursday, December 27, 2012 9:57 PM
    Thursday, December 27, 2012 12:26 PM


All replies