New answers tagged

1 vote
Accepted

Update selected columns containing 0 with NULL

Fist ask yourself if a table structure with a single value column like suggested by Akina in the comments wouldn't be more practical. While stuck with your current design, you need dynamic SQL to ...
Erwin Brandstetter's user avatar
3 votes

JSON_Value problem when adding persisted Computed column

$.requestType and $.tribeRequestType are different properties, so it's unclear what exactly you want to happen here. If you just want to rely on $.requestType then you could do case when json_value(...
Charlieface's user avatar
  • 12.6k

Top 50 recent answers are included