"David Portas" wrote:

> LUIS wrote:
> > I want to execute the following query inside a stored procedure :
> >
> > @Operacion CHAR(4) ,
> > @Tipo CHAR(1)
> >
> > SELECT @Sentencia = 'UPDATE tblFolios SET Espacios = 1234 WHERE Operacion =
> > ' + @Operacion + ' AND Tipo = ' + @Tipo
> >
> > but send me an error indicates values in "@Operacion" and "@Tipo" are
> > considered as unknowed variables. How can I put external parameters inside a
> > Dynamic SQL syntax..?
> >
> > Beforehand, thank you very much.
> >
> >
> > --
> > Luis Garcia
> > IT Consultant
>
> Why would you use dynamic code in this case? Try:
>
> UPDATE tblFolios
> SET Espacios = 1234
> WHERE Operacion = @Operacion
> AND Tipo = @Tipo ;
>
> --
> David Portas
> SQL Server MVP
> --
>