如何为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。我该如何写呢？

数据样本图：

我是新来的。