Hi priyajsr,
Refer the below sqmple query.
SQL
DECLARE @Table1 AS TABLE(Col1 INT,Col2 INT,col3 INT,col4 INT)
INSERT INTO @Table1 VALUES(1,2,3,4)
DECLARE @Table2 AS TABLE(Col1 INT,Col2 INT,col3 INT,col4 INT)
INSERT INTO @Table2 VALUES(5,6,7,8)
SELECT * FROM @Table1
UNION ALL
SELECT * FROM @Table2
Output
Col1 |
Col2 |
col3 |
col4 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |