Auth0 Home Blog Docs

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

sql

#1

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


#2

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: https://stackoverflow.com/questions/25969/insert-into-values-select-from


#3