How to insert image into the table? (1 Viewer)

[accessman2]

Hi,

In MS Access, we can insert image in the table by using right click + insert object on OLE datatype.

But, SQL Server, we don't have option to do that.

Please let me know about it.

Thanks.

 

[jon_sg]

You need to use the image data type (there is no OLE Data type in SQL Server). Like with Jet the SQL table only holds a 4 byte pointer to the images which are stored in data pages.

Regards

Jon