In SQL Server 2005, it won't give the answer other the syntax error since we have to use

'insert into table ' with 'union all' statement for the insertion to be done.