CREATE TABLE [dbo].[t_test] (
	[t_sql] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
) ON [PRIMARY]
GO

insert into t_tes (t_sql,name) values ('select * from view1','select recordset from view1)

DECLARE @query varchar(255)
SET @query = (select t_sql from t_test)
select * from (@query)

DECLARE @query varchar(255)
SET @query = (select t_sql from t_test)
select * from (@query)

DECLARE @query varchar(255)
SET @query = ''
SET @query = 'select t_sql from t_test'
EXEC (@query)

DECLARE @sSQL NVARCHAR(4000)
SELECT @sSQL = t_sql from t_test WHERE -- whatever condition to get the row you want.
EXEC (@sSQL)

We walk in the dark places no others will enter
We stand on the bridge and no one may pass