SQL Server: Read Target Table and create a Declare statement usable in a stored procedure

ReadTableExtractColumnInfoForDeclareStatement.SQL

SELECT
       COLUMN_NAME, 
       DATA_TYPE,
       CHARACTER_MAXIMUM_LENGTH,
	     concat('DECLARE @', COLUMN_NAME, N' ', DATA_TYPE, 
	           IIF(CHARACTER_MAXIMUM_LENGTH IS not null
		    ,  CONCAT(N' (', CHARACTER_MAXIMUM_LENGTH, N')')
		    ,  N''
		       )
		    ) AS [declare]
FROM INFORMATION_SCHEMA.COLUMNS  
WHERE TABLE_NAME = 'Address' 

The address Table: