如何为SQL Server编写SQL存储过程? [关闭]

I have a column (comments) in a table which contains a string in the form |A : some value | B: some value | C : some value | along with some extra text. What I need is to extract the value of A,B,C and add it to the same table under new column A,B,C respectively.

我正在尝试编写一个SQL存储过程,该存储过程可以在同一张表中添加如上所述的新列A,B,C。我该如何写呢?

数据样本图:

我是新来的。