Forum Discussion
gahenry
Jun 20, 2023Copper Contributor
How to use ROWGUIDs
I own a small retail organization and our POS system has a SQL based backend. As you might guess the company that does our POS system is not very helpful when we need custom work so I have been give...
gahenry
Jun 26, 2023Copper Contributor
Thank you for your response!!.. I knew from my readings that was what it was, but I did not know if there was a system parameter or something to access the records the RowGUID relates to.
I have a database that I have been given RO access to and no schema so I am trying to reverse engineer the relationships so I can build reports and do queries
thanks again!
olafhelper
Jun 27, 2023Bronze Contributor
Better use simple integer values for primary key, with a range of 4 billion possible numbers you have a wide range and small footprint; much better then a GUID.