title: Is there a way to add variable value for new column in Alter Table statement?
body: <pre><code>DECLARE @VName      VARCHAR(8)
  
  SET @VNAme = (
                            SELECT TOP 1 xyz 
                            FROM table
                            WHERE abc = something
                      )
  
  ALTER TABLE table_name 
  ADD new_column VARCHAR (8)  NOT NULL DEFAULT @VName
  </code></pre>