Menu
Is there an equivalent of Postgresql's hstore within SQL Server? I'm running SQL Server 2008 with a web application that has an increasingly large need for sparse key/value pairing on the database. It is not feasible in our situation to create a new column each time this occurs. Currently we use a standard column and throw all of this "schema-less" sparse data into a single column and then run checks in the application for the keys we need. This is not very clean/elegant.
I've just recently begun working on another project that uses Postgresql and uses hstore for a very similar problem. hstore is a much cleaner solution to the problem we have, so now I'm wondering if there is an equivalent feature within SQL Server 2008?
937
This module implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value. This can be useful in various scenarios, such as rows with many attributes that are rarely examined, or semi-structured data. Keys and values are simply text strings.
hstore is a PostgreSQL extension that implements the hstore data type. It's a key-value data type for PostgreSQL that's been around since before JSON and JSONB data types were added.
MSSQL does not come with any builtin function similar to "hstore" unless you want to build your function that will return the value based on the key.
113
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
