bulk insert image from relative path
- by Markus
Hi,
I wonder if some can help me out with this little problem. I have the following insert statement:
insert into symbol (sy_id, sy_fg_color, sy_bg_color, sy_icon)
select 302, 0, 16245177, sy_icon = (select * from openrowset(bulk 'K:\mypath\icons\myicon.png', single_blob) as image)
Is it possible to make the path relative in any way? I'm using…