How do I execute a command contained in a string?

[mpruett]

I'm trying to execute a command I've strung together into a string;

I have something like this:


declare @Name varchar(255)

set @name = 'sp_rename ''test_table'',''test_table_2'''


I want to execute the sp_rename statement held in @name. How do I do that?

 

[gmmastros]

declare @Name varchar(255)

set @name = 'sp_rename ''test_table'',''test_table_2'''

[!]Exec (@Name)[/!]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom