Valentin Garcia
Valentin Garcia

Reputation: 495

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'

Upvotes: 0

Views: 38

Answers (1)

Andrew
Andrew

Reputation: 701

You have misspelled UPDATE, you have UPADTE

Upvotes: 1

Related Questions