Sql-server – Implicit conversion from data type varchar to varbinary is not allowed. (SQL)

sql servertsql

Error:

Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.

Any question? I am new to SQL Server

USE schemas
GO

CREATE PROCEDURE Table
    @LineaNegocioId INT,  --null
    @PaisId INT, -- required
    @AreaId INT, --required
    @Nombre VARCHAR(100), --required
    @Descripcion VARCHAR(100), --required 
    @fechaCreacion DATETIME, --required
    @fechaUltimaModificacion DATETIME --null
AS 
BEGIN
    SET NOCOUNT ON

    INSERT INTO Table (LineaNegocioId, PaisId, AreaId, Nombre, Descripcion, fechaCreacion, fechaUltimaModificacion)
    VALUES (@LineaNegocioId, @PaisId, @AreaId, @Nombre, @Descripcion, @fechaCreacion, @fechaUltimaModificacion)

    SET NOCOUNT OFF
END

Best Answer

Either the field Nombre or Descripcion is a varbinary and you must explicitly convert those inputs for your insert clause.

It would look like this.

VALUES (... ,CONVERT(varbinary, [@Nombre or @Descripcion]) ,...)

Related Topic