In SQL Server, it's possible to insert into a table using a SELECT statement

INSERT INTO Table (col1, col2, col3)
SELECT col1, col2, col3
FROM other_table
WHERE sql = ‘cool’
Is it also possible to update via a SELECT? I have a temporary table containing the values, and would like to update another table using those values. Perhaps something like this:

UPDATE Table SET col1, col2
SELECT col1, col2
FROM other_table
WHERE sql = ‘cool’
WHERE Table.id = other_table.id

Thank you
Saanvi Sharma

This community is aimed at providing answers to questions related to the Auth0 service and/or authentication/authorization in general.

The question you have is very out of scope and better answered in a more general technical community forum like StackOverflow where there’s also a great probability of it already being answered.


LMGTFY: sql - Insert into ... values ( SELECT ... FROM ... ) - Stack Overflow