SQL Server

This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .

You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.

SQL Server MIN

SQL Server MIN() function is an aggregate function that is used to find the smallest or minimum value of a column

SQL COUNT

SQL Server COUNT() function is an aggreagate function that returns the number of rows in a table . It sets the number of rows or non NULL column values.

SQL Server SUM

SQL Server SUM function is an aggregate that returns the sum of values for any column in a table.

SQL Server AVG

SQL AVG function is an aggregate function that returns the average of the values.

SQL REPLICATE()

SQL REPLICATE() Repeats a string value a specified number of times.

SQL FULL OUTER JOIN

SQL FULL JOIN or FULL OUTER JOIN returns rows from both left and right tables, with the matching rows from both tables where available. If there is no match, the missing side will have null values.

Displaying line numbers in Query Editor Window

we can enable line numbers to be displayed in Sql Server Query Editor Window.

SQL RIGHT JOIN

SQL RIGHT JOIN or RIGHT OUTER JOIN returns all rows from the right table and the matching rows from the left table.

SQL LEFT JOIN

SQL LEFT JOIN or LEFT OUTER JOIN returns all rows from the left table and the matching rows from the right table.

SQL DATEPART()

SQL DATEPART() function is used to get a part of any specific date , it could be a day , month ,year or time of specific date.

SQL sp_help

SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.

SQL DATEADD()

SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.

SQL TRIM()

SQL Server TRIM() function is used to remove both Leading and Trailing spaces from any given string It was introduced in SQL Server 2017 version… Read More »SQL TRIM()