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...