In Redis, the ZRANGESTORE command works just like the ZRANGE command except that it stores the result in a key.
Basically, it allows us to get all members from a sorted set between a certain range and store them in a new key.
Continue readingAuthor: Ian
SQL Server FOR XML EXPLICIT Examples
In SQL Server, the FOR XML clause allows us to return the results of a query as an XML document. Simply by placing the FOR XML clause at the end of the query will output the results in XML.
When we do this, we have the option of specifying RAW, AUTO, EXPLICIT, or PATH mode. These modes allow us to shape the resulting XML in different ways, and so the mode we choose will determine how the XML is generated.
Below are examples of using EXPLICIT mode when generating XML from a SQL query.
SQL Server FOR XML RAW Examples
In SQL Server, the FOR XML clause allows us to return the results of a query as an XML document. Simply by placing the FOR XML clause at the end of the query will output the results in XML.
When we do this, we have the option of specifying RAW, AUTO, EXPLICIT, or PATH mode. These modes allow us to shape the resulting XML in different ways, and so the mode we choose will determine how the XML is generated.
Below are examples of using RAW mode when generating XML from a SQL query.
Fix “ERR wrong number of arguments for ‘srandmember’ command” in Redis
If you’re getting an error that reads “ERR wrong number of arguments for ‘srandmember’ command” in Redis, it’s probably because you’re calling the SRANDMEMBER command without any arguments.
To fix this issue, make sure you pass the correct number of arguments. At the time of writing, the SRANDMEMBER command requires at least one argument, and accepts an optional second argument.
SQL Server FOR XML AUTO Examples
In SQL Server, the FOR XML clause allows us to return the results of a query as an XML document. Simply by placing the FOR XML clause at the end of the query will output the results in XML.
When we do this, we have the option of specifying RAW, AUTO, EXPLICIT, or PATH mode. These modes allow us to shape the resulting XML in different ways, and so the mode we choose will determine how the XML is generated.
Below are examples of using AUTO mode when generating XML from a SQL query.
SQL Server FOR XML PATH Examples
In SQL Server, the FOR XML clause allows us to return the results of a query as an XML document. Simply by placing the FOR XML clause at the end of the query will output the results in XML.
When we do this, we have the option of specifying RAW, AUTO, EXPLICIT, or PATH mode. These modes allow us to shape the resulting XML in different ways, and so the mode we choose will determine how the XML is generated.
Below are examples of using PATH mode when generating XML from a SQL query.
Redis ZMSCORE Command Explained
In Redis, the ZMSCORE command allows us to get the score of one or members in a sorted set.
Create a Table if it Doesn’t Exist in SQL
When creating a table with SQL, we can specify that the table is only to be created if it doesn’t already exist. Doing this prevents any errors from occurring in the event that the table already exists.
Here are some examples of doing this in various RDBMSs.
Continue readingFix “WRONGTYPE Operation against a key holding the wrong kind of value” when using ZINTER in Redis
If you get an error that reads “WRONGTYPE Operation against a key holding the wrong kind of value” when using the ZINTER command in Redis, it’s probably because you’re passing a key with the wrong data type.
To fix this issue, be sure that each key you pass to the ZINTER command is either a set or a sorted set.
Binary Styles Supported by CONVERT() in SQL Server
Below is a list of binary styles supported by the CONVERT() function in SQL Server. These are the styles that can be used as the third argument to indicate how the input value is formatted when converting to binary.
We can use these styles when the input expression is binary(n), char(n), varbinary(n), or varchar(n).
Continue reading