How to insert table data based on other table id

Ashok Kumar10y ago

how to give unique id in sql database..

0

Ram Nunna10y ago

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

0

Pankaj Kumar Choudhary10y ago

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

0

Abrar Ahmad Ansari10y ago

--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)

0

Vishal Jadav10y ago

hi,

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

Thank you.

0