You are viewing a single comment's thread from:

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

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

8 years ago in #cn by
$0.00
    Reply 0

    Coin Marketplace

    STEEM 0.07
    TRX 0.28
    JST 0.034
    BTC 99939.51
    ETH 3192.61
    USDT 1.00
    SBD 0.54