TSQL: Variable scope and EXEC()

Posted by Joel on Stack Overflow See other posts from Stack Overflow or by Joel
Published on 2009-03-24T15:34:51Z Indexed on 2010/04/21 9:13 UTC
Read the original article Hit count: 311

declare @test varchar(20)
set @test = 'VALUE'

exec('
select '+@test+'
')

© Stack Overflow or respective owner