Summary: In this article, you will learn ORDER BY SQL and how to use the Order By Clause of The SQL Statement With Example to sort the result and set a query by one or more columns. The ORDER BY SQL...
Summary: in this tutorial, you will learn what is Microsoft SQL Server (MS SQL Server) Replication and an overview of how its works. In this article, you will understand the total SQL Server replication topography together with parts, internals, and therefore...
Summary: in this tutorial, you will learn how to use the SQL REPLACE() function with syntax and examples to search and replace all occurrences of a substring with a new substring by a string. SQL REPLACE Function Overview Sometimes, you would...
Summary: in this SQL tutorial, you will learn when/why would you use QUOTENAME? and how to use the QUOTENAME function in (t-SQL) SQL Server to make a string a valid SQL Server delimited identifier. QUOTENAME() SQL Server Function The QUOTENAME() function...
Summary: This SQL Server tutorial explains how to use the PATINDEX function in the SQL Server (Transact-SQL) with syntax and examples to identify the position of a pattern during a string. Definition and Usage The PATINDEX() function In SQL Server (Transact-SQL)...
Summary: In this article, you will learn about the differences between CHAR Vs VARCHAR, and what are the used in string data types. CHAR Vs VARCHAR Overview CHAR and VARCHAR both are the ASCII character data types and both are almost...
Summary: In this article, you will learn SQL Server Data Types such as various data type including character string, unicode character string, numeric, binary string, date & time, and other data types. SQL Server Data Tpes Introduction The data type of...
VARCHAR Vs NVARCHAR Summary: In this article, you will learn the basic differences between the VARCHAR and NVARCHAR data types in SQL Server and How to used to store characters, numbers or special characters. Overview: To store data as characters, special...
Summary: In this article, you will learn What is NVARCHAR data type and how to use the SQL NVARCHAR to store variable-length, Unicode string data. Definition and Usage NVARCHAR data type in SQL Server is used for the purpose to store...
Summary: In this article, you will learn the way to use the SQL Server string function NCHAR data type to store fixed-length, and Unicode character string data. Definition and Usage To store fixed-length and Unicode character string data in the database,...
SQL LTRIM Function Summary: In this article, you will learn What is SQL LTRIM() function and How to use the SQL LTRIM Function to remove leading blanks from a string. Furthermore, we’ll review the new SQL TRIM function in SQL Server...
SQL Lowercase Function Summary: In this article, you will learn What is SQL Server LOWER() function and How to use the SQL LOWER function to convert all characters of a string into the SQL lowercase. Definition and Usage The LOWER() function...
SQL LENGTH Function Summary: In this article, you will learn What is SQL Server LENGTH() function and How to use to Get String Length or the number of characters in a string. Definition and Usage The SQL LENGTH function returns the...
SQL LEN Function Summary: In this article, you will learn What is SQL Server LEN() function and How to use to determine the number of characters of an input string. Definition and Usage The SQL LEN function used to find the...
SQL Left Function Summary: In this tutorial, you will learn about Format SQL LEFT function and how to use them to extract a number of characters from the left side of a given string. Definition and Usage The SQL Server left...
Summary: In this tutorial, you will learn Format Function SQL and how to use them to the specified value in the given format. Definition and Usage Format function SQL is one of the String Function, which is used to format the...
Summary: In this tutorial, you will learn SQL DIFFERENCE() Function and how to use them in an SQL server to compare two SOUNDEX() values of two strings. Definition and Usage The SQL Server DIFFERENCE() function compare between two SOUNDEX values, and...
Summary: In this tutorial, you will learn SQL DATALENGTH() Function and how to use them in an SQL server to counts both leading and trailing spaces when calculating the length of the expression. Definition and Usage In SQL Server the DATALENGTH()...
Summary: In this tutorial, you will learn SQL Server CONCAT_WS() Function and how to use them to join multiple strings together with a separator. Definition and Usage SQL CONCAT_WS() means concatenate with separator. The SQL Server CONCAT_WS() function concatenates two or...
Summary: In this Article, Learn how to use SQL Concat Plus +, furthermore, Plus operator used to add two or more string together. Definition and Usage As the previous Article you have seen that how to use Concat SQL, Furthermore, as...
