On 12/9/2014 10:38 AM, James K. Lowden wrote:
If the subquery to the right of the SET clause produces more than one row, the statement fails.
Are you sure? Normally, a scalar subquery doesn't fail when the resultset contains more than one row - it just silently produces the value from the first row of the first column. I'm pretty sure that's how it works in SQLite (but am too lazy to check).
With SQL Server's syntax, it succeeds with the target holding the "last" value, whatever that was.
Succeeding with the target holding the "first" value doesn't sound like a significant difference.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users