You are viewing a single comment's thread from:

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

in #cn • 7 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 ...

7 years ago in #cn by
$0.00
    Reply 0

    Coin Marketplace

    STEEM 0.29
    TRX 0.12
    JST 0.032
    BTC 63571.79
    ETH 3068.45
    USDT 1.00
    SBD 3.97