Using dynamic Queries

//Example of dynamic query in SQL Server, following example use SQL Server pubs database

DECLARE @SQLSTRING VarChar(15)

SET @SQLSTRING = 'titleauthor'

SELECT @SQLString ='select au_id from '+ @SQLSTRING

EXEC (@SQLString)