B D, Author at Adglob Infosystem Pvt Ltd

SQL – SQRT Function

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

SQL SQRT function is used to find out the square root of any number. You can use a SELECT statement to find out the square root of any number as follows −…

SQL – SUM Function

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

SQL SUM function is used to find out the sum of a field in various records. To understand SUM function, consider an employee_tbl table, which is having the following records − SQL> SELECT * FROM employee_tbl;…

SQL – AVG Function

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

SQL AVG function is used to find out the average of a field in various records. To understand AVG function, consider an employee_tbl table, which is having the following records − SQL> SELECT * FROM employee_tbl;…

SQL – MIN Function

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

SQL MIN function is used to find out the record with the minimum value among a record set. To understand MIN function, consider an employee_tbl table, which is having the following records − SQL> SELECT *…

SQL – MAX Function

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

SQL MAX function is used to find out the record with the maximum value among a record set. To understand MAX function, consider an employee_tbl table, which is having the following records − SQL> SELECT *…

SQL – COUNT Function

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

SQL COUNT function is the simplest function and very useful in counting the number of records, which are expected to be returned by a SELECT statement. To understand the COUNT function, consider an employee_tbl table, which…

T-SQL – Functions

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

MS SQL Server has many built-in functions to perform processing on string or numeric data. Following is the list of all useful SQL built-in functions − SQL Server COUNT Function −…

T-SQL – Indexes

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

Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a…

T-SQL – Transactions

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

A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a…

T-SQL – Stored Procedures

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

The MS SQL Server Stored procedure is used to save time to write code again and again by storing the same in the database and also get the required output by passing…