B D, Author at Adglob Infosystem Pvt Ltd

MongoDB – Advantages

Post author:B D
Post published:August 20, 2021
Post category:MongoDB
Post comments:0 Comments

Any relational database has a typical schema design that shows a number of tables and the relationship between these tables. While in MongoDB, there is no concept of relationship. Advantages…

MongoDB – Overview

Post author:B D
Post published:August 20, 2021
Post category:MongoDB
Post comments:1 Comment

MongoDB is a cross-platform, document-oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on the concept of collection and document. Database The database is a physical…

MongoDB

Post author:B D
Post published:August 20, 2021
Post category:MongoDB
Post comments:2 Comments

MongoDB is an open-source document database and leading NoSQL database. MongoDB is written in C++. This tutorial will give you a great understanding of MongoDB concepts needed to create and…

T-SQL – Numeric Functions

Post author:B D
Post published:August 19, 2021
Post category:T-SQL
Post comments:0 Comments

MS SQL Server numeric functions can be applied to numeric data and will return numeric data. Following is the list of Numeric functions with examples. ABS() The absolute value will…

T-SQL – Date Functions

Post author:B D
Post published:August 19, 2021
Post category:T-SQL
Post comments:0 Comments

Following is the list of date functions in MS SQL Server. GETDATE() It will return the current date along with time. Syntax The syntax for the above function − GETDATE()…

T-SQL – String Functions

Post author:B D
Post published:August 19, 2021
Post category:T-SQL
Post comments:1 Comment

MS SQL Server String functions can be applied on string value or will return string value or numeric data. Following is the list of String functions with examples. ASCII() Ascii…

SQL – String Functions

Post author:B D
Post published:August 19, 2021
Post category:SQL T-SQL
Post comments:0 Comments

SQL string functions are used primarily for string manipulation. The following table details the important string functions − Sr.No.Function & Description1ASCII() Returns numeric value of left-most character2BIN() Returns a string…

SQL – Numeric Functions

Post author:B D
Post published:August 19, 2021
Post category:SQL T-SQL
Post comments:2 Comments

SQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions − Sr.No.Function & Description1ABS() Returns the absolute value of the numeric…

SQL – CONCAT Function

Post author:B D
Post published:August 19, 2021
Post category:SQL T-SQL
Post comments:0 Comments

SQL CONCAT function is used to concatenate two strings to form a single string. Try out the following example − SQL> SELECT CONCAT('FIRST ', 'SECOND'); +----------------------------+ | CONCAT('FIRST ', 'SECOND') | +----------------------------+…

SQL – RAND Function

Post author:B D
Post published:August 19, 2021
Post category:SQL T-SQL
Post comments:1 Comment

SQL has a RAND function that can be invoked to produce random numbers between 0 and 1 − SQL> SELECT RAND( ), RAND( ), RAND( ); +------------------+-----------------+------------------+ | RAND( ) | RAND(…