SQL SELECT – Add Col with default data

select col1, col2, 'XYZ' as col3 from Table

 

Advertisements