You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
lukaseder
changed the title
Emulate INSERT INTO (SELECT ...) by WITH v AS (SELECT ...) INSERT INTO v on SQL Server
Emulate INSERT/UPDATE/DELETE (SELECT ...) by WITH v AS (SELECT ...) INSERT/UPDATE/DELETE v on SQL Server
May 29, 2017
SQL Server doesn't explicitly support inserting into inline views like Oracle:
But this query can be emulated using common table expressions:
Other databases could probably do the same.
This also works with
UPDATE
andDELETE
See also #3607
The text was updated successfully, but these errors were encountered: