Pradeep Raturi

I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.

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 INNER JOIN

SQL INNER JOIN returns the rows from the tables that have matching value in columns.

SQL Server JOINS

A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.

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 DATEDIFF()

SQL DATEDIFF() function is used to calculate the difference between two dates.

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()