EXEC with an EXEC

Question

Is it possible to have an EXEC within an EXEC in SQL?

e.g. EXEC('EXEC ...')

Answer 1

Yes. With an exec statement you can call any statement you could write into a Management Studio query batch including another exec statement.

Answer 2

In SQL Server, yes. try:

EXEC ('EXEC sp_helpdb')

or

EXEC ('EXEC (''EXEC sp_helpdb'')')