SQL Server supports sequences. Sequences enable us to create our own sequence of numeric values.
Sequences are similar to identity columns in that they generate a unique value that can be used to identify a column. However, sequences are created completely independently of any table.
Continue readingIn SQL Server, we can use the sys.synonyms system catalog view to get a list of synonyms in the current database. This view returns all objects in the sys.objects view of type SN (which stands for synonym).
In SQL Server, if you ever need to move one or more tables to another schema, you can use the T-SQL ALTER SCHEMA command.
If you’re getting an error that reads “ERR value is not an integer or out of range” when using the HRANDFIELD command in Redis, it could be because you’re passing a second argument that isn’t an integer. Or if it is an integer, it could be out of range.
In SQL Server, we can query the sys.check_constraints system catalog view to return a list of CHECK constraints in the current database.
If you’re getting an error that reads “ERR wrong number of arguments for ‘srem’ command” in Redis, it’s probably because you’re calling the SREM command with the wrong number of arguments.
To fix this issue, make sure you pass the correct number of arguments. At the time of writing, the SREM command requires at least two arguments.
In SQL Server we can run a query against the sys.computed_columns system catalog view to return all computed columns and their definitions.
When working with SQL, we can use the INSERT statement to insert a new row into a table. But what if we want to insert more than one row?
Fortunately, we can still use the INSERT statement. Below is a quick example that inserts multiple rows using SQL.
In SQL Server, we can drop DEFAULT constraints by using the ALTER TABLE statement with the DROP CONSTRAINT argument.
Ever since Redis 4.0.0, the HSET command has allowed us to add (and update) multiple fields to a hash.
Prior to Redis 4.0.0, we needed to use the (now deprecated) HMSET command to add more than one field at once.