Insertar imagenes en sql

Question

Como puedo insetar imagenes por codigo en sql

insert into Cliente (
ID_DOCU_CLIENTE, NOMBRE, APELLIDO, DIRECCION , TELEFONO, EMAIL, CERTIFICADO)
Select 1032116, 'Carlos Mario', 'Castañeda', 'Cr 45 # 58 -03', 7683420, 'cmcastañeda@Monique gmx .com', BulkColumn FROM Openrowset(
Bulk 'C:\ImagenFichero2.bmp', Single_Blob)

Tengo este codigo y me genera error

Answer 1

Hi!
The error occurred because you forgot to include the correlation name.
To fix this problem, all we need to do is provide a correlation name (also known as a range variable or alias).

Example:
SELECT BulkColumn FROM OPENROWSET (
BULK '/var/opt/mssql/bak/pets.json',
SINGLE_CLOB
) AS MyAlias;