Обсуждение: Transaction id

Поиск
Список
Период
Сортировка

Transaction id

От
Дата:
Is it possible to find "system change ID" in SQL or stored procedures?
By "system change ID" I understand an internal serialized number which could
be used to serialize all SQL submitted into the database?

Thank you in advance, Laimis



Re: Transaction id

От
Jan Wieck
Дата:
lnd@hnit.is wrote:

> Is it possible to find "system change ID" in SQL or stored procedures?
> By "system change ID" I understand an internal serialized number which could
> be used to serialize all SQL submitted into the database?
>
> Thank you in advance, Laimis

Not sure what you exactly envision here. What affects the serialization
of statements is more the time when their transaction commits, that the
time they are executed. From the point of view of the statement, that
order will be determined in the future, so how do you expect this thing
to work?


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #