insert Query for sql server

Question

how to insert the id of another table in a table using query.. i need the query for getting the script.. for example i need the id of tableB in tableA.. i tryd this insert in tableA (name,tableBid)('some name',select id from tableB where name='something') this is not working

Chandresh Pansuriya · Answer

Example : The following statement inserts all addresses from the customers table into the addresses table: INSERT INTO sales.addresses (street, city, state, zip_code) INSERT INTO sales.addresses (street, city, state, zip_code) SELECT street, city, state, zip_code FROM sales.customers ORDER BY first_name, last_name;

Aman Gupta · Answer

Use this Query - INSERT INTO table with value SELECT FROM another table. Explanation - You can use SELECT FROM statement to retrieve data from this table, then use an INSERT INTO to add that set of data into another table, and two statements will be nested in one single query. Hope this makes sense.

Shantanu Pandey · Answer

Hi Abhinandhu, For copying some column from one table to another table, use below query. INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 WHERE condition; For more reference follow below link https://www.w3schools.com/sql/sql_insert_into_select.asp

Ahmed JS · Answer

Hi In think this will help you insert into TableA(id) select id from TableB where name=' something '

Jenith Thakkar · Answer

Insert into TableA( Name , TableBId) Select 'Data' ,( select bId from TableB where Name = 'Something' ) as Bid

Atul Warade · Answer

Hi Abhinandhu, You need to pass that id like insert into tableA values(name, DepID).

Farhan Ahmed · Answer

Foreign key relationship Insert into tableA values(name,tableBId) Like Insert into Employees values(name,Position,Salary,DepartmentId)

insert Query for sql server

Answers (7)