merge two tables data

CREATE TABLE #tbl_1 (sno INT IDENTITY(1,1),name NVARCHAR(100),id INT)

CREATE TABLE #tbl_2 (sno INT IDENTITY(1,1),name NVARCHAR(100),id INT)

INSERT INTO #tbl_1 VALUES ('kiran','9876')

INSERT INTO #tbl_1 VALUES ('praveen','7654')

INSERT INTO #tbl_2 VALUES ('raju','245')

INSERT INTO #tbl_2 VALUES ('vamshi','386')

SELECT ROW_NUMBER() OVER(ORDER BY id DESC) AS sno,*

FROM (

SELECT name,id FROM #tbl_1

UNION ALL

SELECT name,id FROM #tbl_2

) temp

DROP TABLE #tbl_1

DROP TABLE #tbl_2

hi,

try...

Create table #table1
(sno int,
name varchar(20),
id int)

Create table #table2
(sno int,
name varchar(20),
id int)

insert into #table1 values(1,'raju',245),
(2,'vamshi',386)

insert into #table2 values(1,'kiran',9876),
(2,'praveen',7654)

declare @max int
select @max = MAX(sno) from #table1

Insert into #table1
select @max + sno, name,id from #table2

hope this will help you.

JAYRAM12y ago

insert into table1

select * from table2