In SQL Server, you can use the FORMAT() function to return the short day name from a date. FORMAT() is a T-SQL function that enables you to format dates and numbers to a specified format.
This function returns its result as a string. Specifically, it returns it as either a nvarchar or null as the case may be.
As of mongoimport version 100.0.0, you can delete documents in MongoDB based on an imported file. To do this, use delete mode.
When you use delete mode, if an imported document has the same _id value as an existing one in the collection that you’re importing into, the existing document will be deleted.
You can also specify another field or fields (other than the _id field) to be the matching field if required.
When you run queries In MongoDB, you have the option of limiting the documents returned. This is where you specify a maximum number of documents to be returned by the operation.
For example, if an operation would normally return 2,000 documents, but you specify a limit of 1,000, then only 1,000 documents are returned. However, if the operation would only return say, 500 documents, then all 500 are returned (because they don’t breach the 1,000 document limit).
This is a bit like using the TOP clause in SQL Server, or the LIMIT clause in MySQL, MariaDB, PostgreSQL, and SQLite.
If you’ve encountered error Msg 7411, Level 16 in SQL Server, it’s because you need to enable “RPC out” on the linked server that you’re trying to execute code on.
In MongoDB, if you need to delete a document in the mongo shell, you can use:
db.collection.remove() methoddelete commanddb.collection.deleteOne() methoddb.collection.deleteMany() methodThis article provides examples of each.
MongoDB offers various methods for counting the documents in a collection or view. There are also some aggregation operators that enable you to count incoming documents from a previous aggregation pipeline stage.
When using mongoimport, you can use the --jsonArray parameter to import an array of JSON documents.
In MongoDB, you can use the cursor.explain() method or the db.collection.explain() method to determine whether or not a query uses an index.
These methods enable you to view the query plan for the query, which includes whether or not it uses an index.
If you encounter error Msg 15123, Level 16, reading “The configuration option ‘Agent XPs’ does not exist“, you were probably trying to execute EXEC SP_CONFIGURE 'Agent XPs' while advanced options are hidden.
This error is easily fixed.