9 ms·
> SQL prohibits that, separating queries and data manipulation statements. Under SQL Server, you can attach OUTPUT clause to INSERT/UPDATE/DELETE/MERGE and eff
by branko_d 4y ago
> SQL prohibits that, separating queries and data manipulation statements.
Under SQL Server, you can attach OUTPUT clause to INSERT/UPDATE/DELETE/MERGE and effectively have a query that both modifies and returns data. Other DBMSes have similar capabilities.
- thesz 4y agoYes, they do. So what? They are essentially equivalent to two separate statements, a query and a DML statement, executed inside transaction. Meanwhile Prolog does not even have a notion of transactions.