Displaying line numbers in Query Editor Window
we can enable line numbers to be displayed in Sql Server Query Editor Window.
Home » SQL Server Tutorials By Pradeep Raturi »
SQL Server Tutorials By Pradeep Raturi
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 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 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()
SQL CHARINDEX()
SQL CHARINDEX() function searches for a substring inside a string starting from a specified location.
SQL SUBSTRING()
SQL SUBSTRING()functions extracts a substring with a specified length starting from a location in an input string.
SQL DATALENGTH Function
SQL DATALENGTH() function is used to return the number of bytes used to represent a given string.
SQL Server RTRIM()
SQL Server RTRIM() function is used to trim trailing characters from a character string.
SQL Server LTRIM()
SQL Server LTRIM() function is used to trim leading characters from a character string.
SQL SERVER REPLACE
SQL REPLACE() function is used to replace all occurrences of a substring in a string with a new substring .
SQL LEN()
SQL LEN() function is used to count the number or length of character in given string. It returns integer value always and null for empty string.