cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michael-w
Frequent Visitor

How the ‘versionnumber’ field is generated?

I found that the versionnumber field is not a updated sequentially.

I created a record, the versionnumber is initialized at 1291821.

Then I update this record, it become to 1291842.

I want to know what's the meaning behind versionnumber? Could it start with 1 and increased by 1 when update?

 

Tip: I query these data from SSMS according  Use SQL to query data (Preview)

michael-w_0-1611823023942.png

michael-w_1-1611823273554.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
HSheild
Super User
Super User
2 REPLIES 2
HSheild
Super User
Super User

Thanks, I got it. versionnumber field's data type is rowversion, rowversion is a data type in SQL Server.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,618)