Before insert how to check the records if it exists or not

Question

hi I created two tables like create Table A (pid bigint pname varchar psource varchar(10)) create Table #temp (id bigint name varchar source varchar(10)) table A having lakhs of rows and table #temp having lakhs of rows i want to check the records based on #temp table and insert into Table A. how to check the records before insert values from #temp table to table A insert into A (pid pname psource ) select id name source from #temp Please give me the solution for the above query.

Tapan Patel · Answer

Hivijay reddy You can use something as below. INSERT INTO TABLE_A SELECT COLUMNS FROM TABLE_B WHERE NOT EXIST( SELECT YOUR_UNIQUE_KEY FROM TABLE_A WHERE UNIQUE_KEY= VALUE OF UNIQUE_KEY )

Vinay Singh · Answer

hi check the query if not exists( select * from #temp where id=1111) begin insert into A (pid pname psource ) select id name source from #temp end

Sanjeev Sriramoju · Answer

Take table 1 Take table 2 you want to insert into table 2 which are not in table 1. we can use NOT IN  clause.Below is the sql query to resolve it Insert into table 1 Select * from table 2 where ID not in (select IDfrom table1)

Vishal Jadav · Answer

Hi If your #temp table contains duplicate ids then you need to remove them first. then insert into A (pid pname psource ) select id name source from #temp where id not in (select pid from A) . If you have any query please let me know. Hope it helps. Thanks.

Jisny Av · Answer

if(EXISTS ( SELECT column - name FROM table - name WHERE condition )) begin insert into table-name values(val1val2...) end

vijay reddy · Answer

hi vinay as per your suggestion if not exists( select * from #temp where id=1111) begin insert into A (pid pname psource ) select id name source from #temp end i want to compare with id = pid before inserting how can i do it

Vinay Singh · Answer

It's the pid

vijay reddy · Answer

hi vinay thanks for your response in that id is having more than 1000 records how can i check thanks vijay

ketan borsdiya · Answer

Hi Vijay You may use Merge in sql. Check below merge statements it may help you. CREATE PROCEDURE PRC_Test @table As dbo.UDTT_Test READONLY AS BEGIN MERGE AS T USING @table AS S ON T.MDN = S.MDN WHEN NOT MATCHED THEN INSERT (MDNRES1RES2RES3ChangeMode) VALUES (S.MDNS.RES1S.RES2S.RES3S.ChangeMode) WHEN MATCHED THEN UPDATE SET MDN=S.MDN RES1=S.RES1 RES2=S.RES2 RES3=S.RES3 ChangeMode=S.ChangeMode; END