I have this following example
DECLARE @img AS VARBINARY(MAX)
-- Load the image data
SELECT @img = CAST(bulkcolumn AS VARBINARY(MAX))
SINGLE_BLOB ) AS x
-- Insert the data to the table
INSERT INTO Items (ItemID, ItemNumber, ItemDescription, ItemImage)
SELECT NEWID(), 'MS1001','Microsoft Mouse', @img
what I want to do is replace
with a variable file name
I tried taking out the apostrophes, and adding @file_location (which I declared) but it doesn't seem to like it.
Do I need to do something like
' " + @file_location + "'
an example would be appreciated. Thanks