Click here to Skip to main content
12,065,045 members (38,789 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: MySQL
hi

i Have 2 tables
emp1 and emp2

now i want 2 insert in emp1 from emp2 which is UID field contains 0 value
if employee already exit in that emp1 table then it will automatically delete and newly add from emp2
Posted 26-Feb-13 19:13pm
Comments
Prakash Thirumoorthy 27-Feb-13 0:22am
   
can u brief your table fields...? what if employee already exit? question is not clear... ?
AnnuBhai 27-Feb-13 0:37am
   
emp code
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

begin try
	begin tran
		delete from emp1 where empid in
		(
			select empid from emp2
		)
 
		insert into emp1
		select * from emp2 where empid not in
		(
			select empid from emp1
		)
	commit tran
end try
begin catch
	rollback tran
	raiserror('transaction failed !', 16, 255)
end catch
  Permalink  
Comments
AnnuBhai 27-Feb-13 0:56am
   
wer i paste this code
AnnuBhai 27-Feb-13 0:56am
   
dineshshp
AnnuBhai 27-Feb-13 1:21am
   
actually i am using mysql
AnnuBhai 27-Feb-13 7:51am
   
Condition also der

Fing1 not null and UID also not null

plz helpme yaar
AnnuBhai 27-Feb-13 7:52am
   
i getting error in line insert statement
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

In SqlServer Stored Procedure.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web04 | 2.8.160204.4 | Last Updated 27 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100