Jump to content

Talk:Update (SQL)

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 70.169.134.132 (talk) at 07:35, 16 February 2006. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Maybe the article does not reflect typical syntax from real databases. For example, this is valid in Microsoft SQL server: 

UPDATE authors
SET state = 'ZZ' 
FROM (SELECT TOP 10 * FROM authors ORDER BY au_lname) AS t1
WHERE authors.au_id = t1.au_id

More info here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ua-uz_82n9.asp

Retrieved from "https://en.wikipedia.org/w/index.php?title=Talk:Update_(SQL)&oldid=39850278"