3 ms·
How do you query json with SQL server like let's say you have one data point like this { "id": 42, "quantity": 12, bla bla bla And you want rows where this co
by mcny 2y ago
How do you query json with SQL server like let's say you have one data point like this
{ "id": 42, "quantity": 12, bla bla bla
And you want rows where this column has quantity and quantity ≥ 20
How do you do it if you encode everything as base 64?
- isoprophlex 2y agoYou slap a full text index on the base64 string. There's only a finite number of base64 substrings for the un-encoded substrings "id", 42, etcetera, so you first filter on those. Then you decode those full strings into json and do the final filtering application side. Easy!
- 6510 2y ago<joking>have col names id, quantity, json and greaterthan20
- thih9 2y agoThis is only a joke until a manager hears it. Then it’s part of the Q1 roadmap and we will refactor it in Q3.