Listing 1: Different Cases for Column Names Can Cause Error

PRINT 'CREATE TABLE #tmplg' 
PRINT '(' 
PRINT 'DBName varchar(32),' 
PRINT 'LogSize real,' 
PRINT 'LogSpaceUsed real,' 
PRINT 'Status int' 
PRINT ')'
.
.
.
PRINT 'SELECT @logsize= logsize FROM #tmplg WHERE dbname = ' + char(39) + 
@DB + char(39)