Daily Archives: 19. November 2008

Dynamic SQL – must declare scalar variable

Posted on 19. November 2008 by Bennett

I ran into a situation today where I was generating dynamic SQL that appeared to be valid.  I could take the generated SQL strings and execute them with no issues, but when executed dynamically, I got the error message “Must … Continue reading →

Posted in T-SQL | Comments Off on Dynamic SQL – must declare scalar variable