Does anybody know how I can run some SQL Server instruction stored in variable in stored procedure (for instance @var = 'SELECT AuthorName FROM Authors&#39. I need it for creating dynamic sql select queries.