在SQL Server 2012列中查询JSON

If you truly don't have control to change the database, you can accomplish this by parsing out the value with SUBSTRING like below, but it's leading down a very unhappy path:SELECT *FROM tb1JOIN tb2 on tb2.bvin = SUBSTRING( tb1.json ,CHARINDEX('"bvin":"', tb1.json) + LEN('"bvin":"') ,CHARINDEX('"', tb1.json, CHARINDEX('"bvin":"', tb1.json) + LEN('"bvin":"')) - CHARINDEX('"bvin":"', tb1.json) - LEN('"bvin":"') )可悲的是，这很容易. 这篇关于在SQL Server 2012列中查询JSON的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！