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.
This website provides a SQL Tutorial, 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.
A JOIN clause is used to combine two or more related tables. Tables are related to each other using foreign key constraints.
SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.Â
SQL DATEADD() function adds a number to a specified date part of an input date and returns the modified date.
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()
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.
SQL Server RTRIM() function is used to trim trailing characters from a character string.
SQL Server LTRIM() function is used to trim leading characters from a character string.
SQL EOMONTH() function is a date function , it returns the last day of the month of a specified date, with an optional offset.
SQL delete statement is used to delete records from table based on specific conditions which are passed in where clause.
A PRIMARY KEY constraint uniquely identifies each record in a table .
A COMPOSITE KEYÂ is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.
SQL SERVER DISTINCT keyword is used to remove all the duplicate records and fetching only unique records from any table.