How do i pass database name as parameter to stored procedure

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Khan Abrar Ahmed12y ago
hi .
please add the print @query befor exec(@query) and check the statement is coming proper or not.
ant the error heere
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='

set @query =@query+'''+@schoolName+'''
print @query
exec (@query)
go

0