SQL update part of an entry
Not really related to EV operation.
I am in the proces of preparing for a DR test
The indexes are running on file-servers.
I have to update rows in SQL.
The command I use (amongst others) is as below.
SET IndexRootPath = 'server92513\EVIndex\Location1\EVIndex\index1'
WHERE IndexRootPath = '\\server95513\EVIndex\Location1\EVIndex\index1'
I have about 240 rows to change.
Is it possible within SQL, using some nifty selection option to change only the value 'server92' to the value 'server95'? This would leave less room for errors, as indexlocations are regularly moved, and several are added also. As you can guess, I am not a SQL guru :-). Any ideas welcome!