Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 106917

Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server (for this, use the sql-server tag), nor does it refer to specific dialects of SQL on its own.

2
votes
If you're storing a history of changes (drafts) with a flag to mark the publicly viewable state then your submit changes button can just set all the state on the page to be the publicly viewable state …
answered Oct 26 '15 by Sirisian
6
votes
You're essentially asking about how locks are performed and when. This will be covered in the documentation for each database implementation. As an example for PostgreSQL the required reading is: ht …
answered Oct 13 '15 by Sirisian