sql server 存储过程 中处理json

ALTER PROCEDURE [dbo].[sp_QueryLIST_Json]
(
@compid   VARCHAR(10),
@Opid    VARCHAR(10),
@status  INTEGER ,


@string  VARCHAR(max)




)
AS
-- DECLARe  @string VARCHAR(8000)
-- SET @string ='[ { "mark": "0", "CContractCode": "srq0040", "ContractUID": "{sssss}", "stgid": "0", "NotPumpPrice": "1.11111", "PumpPrice": "1.11111", "TowerCranePrice": "1.11111", "PriceDifference": "1.11111", "PriceETime": "2017-9-9", "CreateTime": "2017-9-9" }, { "mark": "0", "CContractCode": "srq0041", "ContractUID": "{sssss}", "stgid": "0", "NotPumpPrice": "1.11111", "PumpPrice": "1.11111", "TowerCranePrice": "1.11111", "PriceDifference": "1.11111", "PriceETime": "2017-9-9", "CreateTime": "2017-9-9" } ]'
-- 






IF  @status =1