This works

Insert into test Select 'A' union Select 1;

also

Insert into test Select 1 union Select 'A'; works

but only select statement not works.

Select 1 union Select 'A';

Give error :

Syntax error converting the varchar value 'A' to a column of data type int.