[SQL] Use dynamic database name in a stored procedure [duplicate]

I'm trying to create a SQL query to dynamically change database name passed in as @name variable, when trying to execute the stored procedure, I get an error message.

CREATE OR ALTER PROCEDURE [schema].[procname]
(@name varchar(20))
AS
BEGIN
DECLARE @sql nvarchar(max);

SET @sql = N'SELECT ID, Name, [col1], [col2]
FROM @name.[schema].[table]';

EXEC sp_executesql @sql;
END
GO

EXEC [schema].[procname] 'DVMTIONAPP'


I get this error:

Must declare the scalar variable "@name".
​

Continue reading...