How do i pass database name as parameter to stored procedure

Question

Hello Everyone,


I am trying pass database name as parameter to a stored procedure, but iam having issues doing it, please check my script, and let me know if i am missing anything:


set quoted_identifier off
go
ALTER procedure [dbo].[usp_accessdb] 
@SchoolAngelPortalDB varchar(128),
@GSC_NewSchoolCore varchar(128),
@schoolName varchar(50)= NULL
as 
declare @query varchar(1000)
set @query = 'SELECT pp.title, pp.surname,pp.firstname,pp.phone,pp.email,rcd.reg_code,pp.genCode
    FROM '+@SchoolAngelPortalDB+'.dbo.primaryparent pp
    LEFT JOIN '+ @GSC_NewSchoolCore +'.dbo.registration_codes rcd ON pp.genCode = rcd.reg_code
WHERE Sch.Name='+@schoolName
   
exec (@query)
go


When trying to execute the procedure,using the below script:


[usp_accessdb]"SchoolAngelPortalDB","GSC_NewSchoolCore","Greenwood House School"

 I have this error:

Incorrect syntax near 'House'.

Please any assistance will be appreciated.