insert Query for sql server

Abhinandhu K R

6y1.1k

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chandresh Pansuriya6y ago
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;
+3
Aman Gupta6y ago
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.
+2
Shantanu Pandey6y ago
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
+3
Ahmed JS6y ago
Hi

   In think this will help you
insert into TableA(id) select id from TableB where name='something'
+3
Jenith Thakkar6y ago
1. Insert into TableA(Name,
2. TableBId)
3. Select 'Data',(select bId from TableB where Name = 'Something') as Bid
+3

Hi Abhinandhu,

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

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