Exécution de requête SQL et résultat

DECLARE @SQL varchar(1000) // Attention a la taille!!!
SET @SQL = 'SELECT TOP 1 ' + @FieldName + ' AS value FROM ' + @FlowName + ' WHERE ' + @IDName + ' = ''' + @IDValue + ''''; 

EXEC (@SQL)

DECLARE @SQL varchar(1000) // Attention a la taille!!!
declare  @table(value varchar(255))
insert into @table
 exec ('SELECT TOP 1 ' + @FieldName + ' AS value FROM ' + @FlowName + ' WHERE ' + @IDName + ' = ''' + @IDValue + ''''); 
set @SQL = (select top 1 value from @table)
select @SQL 

DECLARE @SQL varchar(1000) // Attention a la taille!!!
declare @table table (value varchar(255))
insert into @table
 exec ('SELECT TOP 1 ' + @FieldName + ' AS value FROM ' + @FlowName + ' WHERE ' + @IDName + ' = ''' + @IDValue + ''''); 
set @SQL = (select top 1 value from @table)
select @SQL 

SET @SQL = 'SELECT * FROM ' + @TableName 
EXEC(@SQL) 

declare @table varchar(200)
set @table = 'maTable'
declare @SQL varchar(200)
set @SQL = 'SELECT * FROM '+@table

exec (@SQL)