CREATE PROCEDURE spDbFileAllocation
   @db VARCHAR(255) = ''
AS BEGIN
   DECLARE @qry VARCHAR(MAX) = '';

   SET @qry = CONCAT(
    ...