2
Given your test data, this will parse out the section of the string you want between either the first semi-colon after the PATH=, or the end of the string if that doesn't exist. From here, you should be able to use an update to replace that section of the string.
Further reading: Get The Text Between Two Delimiters
SELECT
x.*,
SUBSTRING(x....
1
I want to change a part of some strings in the PARAMETERLIST column.
This is just one of the reasons that you do not store multiple data items in a single column.
Any "string" manipulation on these values is going to be complicated, cumbersome and, most importantly, slow. Don't do it (any more).
Normalise your data and break these mini-monoliths ...
1
This is an easy one. Albeit if you work in a Swiss-German organisation like I do and have to install German SQL Server instances on Windows Servers, which have been set up to use the location Switzerland which results in a Swiss-German keyboard layout and date-time settings.
The solution depends on the version of the OS installed...
Windows Server 2016
On a ...
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2012 × 4415sql-server × 3188
performance × 274
t-sql × 257
availability-groups × 244
sql-server-2008 × 179
sql-server-2008-r2 × 166
backup × 159
sql-server-2014 × 128
ssms × 128
replication × 111
permissions × 111
restore × 95
ssis × 94
query-performance × 91
index × 89
clustering × 85
security × 82
transaction-log × 82
sql-server-agent × 80
stored-procedures × 77
memory × 75
execution-plan × 72
windows-server × 70
sql-server-2016 × 67