SQL : Creating a blank column in the SELECT

Question

Hi Team - I am trying to create to create blank column while writing a SELECT like below.

Could you help resolve the issue below ?

SELECT 
	*
	, '' AS PROCESSING_FLAG  
INTO #CA_CONTRACTLINES_FLAGPROCESSING_STG
FROM #CA_CONTRACTLINES
#CA_CONTRACTLINES_FLAGPROCESSING_STG),its giving me the below error. 
UPDATE #CA_CONTRACTLINES_FLAGPROCESSING_STG
		SET PROCESSING_FLAG = 'C!'
String or binary data would be truncated.
SELECT 
	*
	, NULL AS PROCESSING_FLAG  
INTO #CA_CONTRACTLINES_FLAGPROCESSING_STG
FROM #CA_CONTRACTLINES
UPDATE #CA_CONTRACTLINES_FLAGPROCESSING_STG
		SET PROCESSING_FLAG = 'C!'
Conversion failed when converting the varchar value 'C!' to data type int.
AS PROCESSING_FLAG 

Answer 1

Try

SELECT 
	*
	, cast(NULL as varchar(10)) AS PROCESSING_FLAG  -- specify desired column's type
INTO #CA_CONTRACTLINES_FLAGPROCESSING_STG
FROM #CA_CONTRACTLINES