Tried with select all text and updating fields, but its not solving the purpose....
The tooltip for Cross References (Word 2007 - Ribbon, References) says that Cross References get automatically updated if the content is moved to another location, but this does not happen.
I know it's not scientifically rigorous to do a comparison like this when I don't have equal experience with both databases, but this is not an academic exercise – it's a real-world comparison.
I have done my honest best to get my facts about MS SQL Server right – we all know it is impossible to bullshit the whole internet.
Maybe MS SQL Server kicks Postgre SQL's arse as an OLTP backend (although I doubt it), but that's not what I'm writing about here, because I'm not an OLTP developer/DBA/sysadmin. Do please use it if you wish; I will do my best to respond. This section is a comparison of the two databases in terms of features relevant to data analytics.
CSV is the de facto standard way of moving structured (i.e. All RDBMSes can dump data into proprietary formats that nothing else can read, which is fine for backups, replication and the like, but no use at all for migrating data from system X to system Y.
Here is an example below: The problem occurs when you have “cross-references” (or more accurately, “fields”) such as figure numbers or chapter numbers.
The easiest way to do this is to press Ctrl A (which selects the entire document) and then press F9 (which updates all the fields in the document).
NOTE: You must be using automated caption numbering, Word’s heading styles (mostly), and automated cross-references (x-refs) for these steps to work.
If you have a document with several sections and automated table/figure captions and x-refs to these, you might wonder how you can update these numbers etc.
In some instances, however, you may have a need for a single footnote to have multiple references within a document.
For example, some scientific journals require that footnotes not be repeated, but that the same footnote reference be repeated within the main text, and that the references go to a single footnote.