Mrbezawada
Pilla Bewarse Username: Mrbezawada
Post Number: 100 Registered: 10-2011 Posted From: 205.172.134.23
Rating: N/A Votes: 0 | Posted on Thursday, October 15, 2015 - 10:36 am: | |
KJ, Check this DROP TABLE #Source DROP TABLE #Destination CREATE TABLE #Source ( id INT , name NVARCHAR(10) , salary FLOAT ) INSERT INTO #Source VALUES (1,'Siva',10.00); INSERT INTO #Source VALUES (2,'Rama',20.00); INSERT INTO #Source VALUES (3,'Krish',30.00); CREATE TABLE #Destination ( id INT , name NVARCHAR(10) , salary FLOAT ) INSERT INTO #Destination SELECT * FROM #Source SELECT * FROM #Source SELECT * FROM #Destination INSERT INTO #Source VALUES ( 4, 'Brahmi' , 40.00) UPDATE #Source SET name = 'Rams' WHERE id = 2 SELECT * FROM #Source SELECT * FROM #Destination INSERT INTO #Destination SELECT S.* FROM #Source S LEFT JOIN #Destination D ON S.id = D.id WHERE D.id IS NULL UPDATE D SET d.name = s.name , d.salary = s.salary FROM #Source S LEFT JOIN #Destination D ON S.id = D.id WHERE d.name <> s.name OR d.salary <> s.salary SELECT * FROM #Source SELECT * FROM #Destination Bezawada Bewarse Batchey
|