(That has somewhat come up as part of Bill's current FAQ...)

AFAIK, each SQL statement in the docs is documented with a "Side effect" paragraph that tells whether the statement will force an implicit (automatic) commit, cf. for the ALTER TRIGGER statement:

Side effects

Automatic commit.

However, it's not always that clear whether a statement will do so (and SET OPTION might be overseen, for example).

Sometimes it would be handy if the docs would also contain a list of all statements that may have an automatic commit as their side effect - similar to Glenn's list of all statements that may trigger an implicit checkpoint.

So I would suggest such an enhancement in the documentation.

asked 31 Jan '14, 08:46

Volker%20Barth's gravatar image

Volker Barth
29.6k293444650
accept rate: 32%

I have forwarded your suggestion to the documentation team.

(31 Jan '14, 09:25) Mark Culp

Hi Volker, We do try to minimize the use of lists as stand-alone topics in the docs because they can fall out of date, and don't always contain enough context-specific information that may be required, causing confusion for readers.

In this specific case, go to DCX and narrow search scope (Scope tab) to the SQL Reference guide, and then search for "automatic commit", including the double quotes. The list returned should be what you need because we standardized to the wording "Automatic commit" in the Side Effects section of each applicable statement.

I'll look into what we're saying about SET OPTION.. Thank you!

permanent link

answered 24 Feb '14, 10:32

Laura%20Nevin's gravatar image

Laura Nevin
1.1k2713
accept rate: 66%

Laura, thanks for the detailed explanation, that search facility makes sense to me and seems more reliable than a possibly out-of-date list. - And I certainly would not have thought of system procedures that also may force an automatic commit.


BTW, is there a way to change the sort order of the search results? Currently, they seem to appear in somewhat random order:

  • GRANT USAGE ON SEQUENCE statement
  • DROP CERTIFICATE statement
  • DROP REMOTE MESSAGE TYPE statement [SQL Remote]
  • ...
  • DROP MESSAGE statement
  • sa_refresh_text_indexes system procedure
  • REVOKE CONSOLIDATE statement [SQL Remote]
  • ...

The CREATE statements are mostly at the end of the list. Apparently, it would be easier if all CREATE statements would be listed in a contiguous block...

(24 Feb '14, 15:34) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×106
×78
×3

question asked: 31 Jan '14, 08:46

question was seen: 631 times

last updated: 24 Feb '14, 15:35