How to execute SQL statements saved in a table with T-SQL

We can execute a sql statement which is stored in sql table using below query.


Create table Temp (id int identity(1,1),name varchar(10))

Id    Name
1     Suresh
2.    Mahesh
3.    Rakesh
4.    John

Create table  Temp1 (sqlquery varchar (50))

id    Sqlquery
1     Select * from temp
2.     Select Id from temp
3.     update temp set name='XYZ' where id=3

DECLARE @Query nvarchar(50) 

SET @Query = (SELECT sqlquery FROM temp where id =1) 

EXEC sp_executesql @Query

Result  : 

Id    Name
1     Suresh