sp_executesql wrong syntax

Question

sp_executesql wrong syntax

I get this error

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '='.

When I execute this

 exec sp_executesql N' UPADTE SYS_Configuracion
                       SET Valor = @Valor
                       WHERE Codigo = @Codigo',
                    N'@Codigo nvarchar(15),@Valor nvarchar(1)',
                    @Codigo=N'CAP_CERTIF_ADIC',@Valor=N'0'

sql-server

tsql

asked on Stack Overflow Oct 11, 2018 by

Valentin Garcia • edited Oct 12, 2018 by

marc_s

1 Answer

You have misspelled UPDATE, you have UPADTE

answered on Stack Overflow Oct 11, 2018 by

Andrew

User contributions licensed under CC BY-SA 3.0