You have posted in a SQL Server 2016 forum, so I would suggest looking at Always Encrypted.  I am currently working on a POC that will explore this technology.  Just...

Geez, why are people coming here expecting some one here to write code for them for free?

Thom A actually provided a possible solution, and it has to be implemented in the application.  It would also have to be serializable to accomplish the lock.  The application would...

From what I have been finding I don't even know if Microsoft is actually supporting Sync Framework anymore.

Well, after many posts it looks like we are finally getting the information needed to better help.  From the OP's latest post what is needed is to determine the order...

I know I shouldn't be but it still amazes me how people can be a part of this community for years but still ask such newbie questions.  And no, I...

Check out this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/

You would have to write some interesting dynamic SQL to return the entire data set, then determine if two columns between the two sets of data completely match and not...

If all you want are the data columns where data is different between two rows of data, which could mean different columns for different sets within the entire set, you...