How to assign double quotes in a variable?

[NenadV]

This doesn't work.

vDBSchema = 'DB Name.dbo.';

SQL select * from $(vDBSchema)Invoices

and this works in the SQL Management Studio:

select * from from "DB Name".dbo.Invoices

[steeefan]

Try one of these:

SET vDBSchema = '"DB Name".dbo';
LET vDBSchema = chr(34) & 'DB Name' & chr(34) & '.dbo';

[NenadV · Accepted solution]

Thanks Steeefan. This has worked: vDBSchema = "'DB Live.dbo.'";