You are viewing a single comment's thread from:

RE: 请MSSQL高手指点一下JSON的问题

in #cn • 9 years ago

JSON_VALUE(cm.json_metadata,'$.tags[0]') tag1,
JSON_VALUE(cm.json_metadata,'$.tags[1]') tag2,
JSON_VALUE(cm.json_metadata,'$.tags[2]') tag3,
JSON_VALUE(cm.json_metadata,'$.tags[3]') tag4,
JSON_VALUE(cm.json_metadata,'$.tags[4]') tag5
from Comments cm WITH (NOLOCK)
where ...

9 years ago in #cn by
$0.00
    Reply 0

    Coin Marketplace

    STEEM 0.06
    TRX 0.29
    JST 0.053
    BTC 70130.59
    ETH 2062.24
    USDT 1.00
    SBD 0.49