How TRY_PARSE() Works in SQL Server

In SQL Server, the TRY_PARSE() function returns the result of an expression, translated to the requested data type, or NULL if the conversion fails.

Basically, it works the same as the PARSE() function, except that it returns NULL instead of an error if the cast fails.

Both functions are intended for converting string values to either date/time or number types.

Read more

How PARSE() Works in SQL Server

In SQL Server, the PARSE() function returns the result of an expression, translated to the requested data type.

Basically, it enables us to parse a string expression to the specified data type. It’s intended for converting string values to either date/time or number types.

The PARSE() function can be handy when attempting to convert with CAST() or CONVERT() fails. The PARSE() function is able to parse the expression, and this may result in certain values being converted that wouldn’t normally be able to be converted.

Read more

Redis HSTRLEN Command

The Redis HSTRLEN command allows us to get the length of a value that’s stored in a hash. It returns the string length of the value associated with the specified field at the hash stored in the specified key.

Read more

Redis ZUNIONSTORE Command Explained

In Redis, the ZUNIONSTORE command works in the same way that ZUNION works, except that it stores the result in a key that we specify.

In other words, it computes the union of the specified sorted sets, then stores the result in the specified key.

Read more

Redis ZREMRANGEBYLEX Command Explained

In Redis, the ZREMRANGEBYLEX command enables us to use a lexicographical range to remove members from a sorted set. That is, we can specify that all members between a given lexicographical range are removed.

This relies on all members having the same score (which forces lexicographical ordering).

Read more