MSSQL - Fix Error - Could not find stored procedure 'SELECT * FROM Customers'.

Watch this example on YouTube

Error - Could not find stored procedure 'SELECT * FROM Customers'.

To fix it replace

Declare @Test as varchar(max) = 'SELECT * FROM Customers'
Exec @Test

with

Declare @Test as varchar(max) = 'SELECT * FROM Customers'
Exec (@Test)