I found this code and I've tried this before on my setup and I got it to work in a test environment.
Now, the project is moving forward.
However, it occurred to me that on my test setup, the C: drive of the SQL Server and the C: drive of where the file resides are the same.
That will not be true in the production world.
The file will be on the C: drive of the client W/S.
Is that an issue or am I conjuring up non-existing issues (again)?
If is an issue, how to handle it?
INSERT Production.ProductPhoto (
ThumbnailPhoto,
ThumbnailPhotoFilePath,
LargePhoto,
LargePhotoFilePath)
SELECT ThumbnailPhoto.*, null, null, N'tricycle_pink.gif'
FROM OPENROWSET
(BULK 'c:\images\tricycle.jpg', SINGLE_BLOB) ThumbnailPhoto
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.