How to insert table data based on other table id

Question

Hi, I want to insert values to one table based on other table id. if ID match then insert the data. Please give me sample stored procedure query. Thanks

Ashok Kumar · Answer

how to give unique id in sql database..

Ram Nunna · Answer

Hi, Please find below answer. we have two tables table1,table2. If table2 id is matchs with table2 data then insert into table 1. create procedure usp_insert_data @id int, @col1, @col2 as if exists (select 1 from table2 where id=@id) insert into table1(col1,col2) values( @col1,@col2 ) Thank you

Pankaj Kumar Choudhary · Answer

Hello! Shivakumar You can achieve this task by one of the below method 1. You can create a stored procedure . 2. You can use a instead of trigger

Abrar Ahmad Ansari · Answer

--from outside id comparing insert INTO Employees(FirstName,MiddleName,LastName) select emp.FirstName,emp.MiddleName,emp.LastName from COMM.VwActiveEmployee emp where emp.EmployeeID=@id --inserting table checking id exists then insert insert INTO Employees(FirstName,MiddleName,LastName) select emp.FirstName,emp.MiddleName,emp.LastName from COMM.VwActiveEmployee emp where EXISTS(select 1 from Employees e where e.EmployeeID=emp.EmployeeID)

Vishal Jadav · Answer

hi, Can you please give a little example so i can understand the requirement and try to give u the query. Thank you.

How to insert table data based on other table id

Answers (5)