I’m trying to think of a way of comparing text pasted in to a MultiLine TextBox (source) to the exact same text sitting in a destination (a SQL Server table).
Basically, I want to compare what some clients have, which is comprised of hundreds of SQL Insert scripts as well as version numbers, to what I have in my master file as well as version numbers.
When I click a button, I want to run a script that compares the lines in the MultiLine TextBox including the version number, to what is contained in the SQL Server table.
So, the client will paste the text, below, into a MultiLine TextBox in a web page:
INSERT INTO Customers (CustomerName, Country) ver 1.2.1
INSERT INTO Customers (Person, City) 1.1.1
INS ...
Go to the complete details ...