TipsMake
Newest

Program - Page 64

Learn basic programming with C, C++, Python, JavaScript, PHP, CSS, HTML5 programming languages. You can also find tutorials on databases, SQL Server here.

CHARINDEX function in SQL Server
25 May 2019

CHARINDEX function in SQL Server

The CHARINDEX function in SQL Server is used to search for a substring within a large string starting from the specified position.

DATALENGTH function in SQL Server
25 May 2019

DATALENGTH function in SQL Server

The article will explore and show you how to use the DATALENGTH function in SQL Server to display the number of bytes used to represent an expression ..

LEFT function in SQL Server
25 May 2019

LEFT function in SQL Server

The LEFT function in SQL Server allows you to extract a substring from a large string, starting from the leftmost character.

LEN function in SQL Server
25 May 2019

LEN function in SQL Server

The LEN function in SQL Server returns the length of the specified string. It is important that the LEN function does not include whitespace characters at the end of the string

LOWER function in SQL Server
25 May 2019

LOWER function in SQL Server

The article will explore and show you how to use the LOWER function in SQL Server to convert letters in a specified string to lowercase.

LTRIM function in SQL Server
25 May 2019

LTRIM function in SQL Server

LTRIM function in SQL Server is used to delete all space characters from the first position (left positions) of the string.

REPLACE function in SQL Server
25 May 2019

REPLACE function in SQL Server

REPLACE function in SQL Server is used to replace all occurrences of substring a to a new substring b in a given string.

RIGHT function in SQL Server
25 May 2019

RIGHT function in SQL Server

The article will explore and guide you how to use the RIGHT function in SQL Server to extract some characters from the right side of a given string.

RTRIM function in SQL Server
25 May 2019

RTRIM function in SQL Server

The RTRIM function in SQL Server is used to delete all space characters from the last position (the right positions) of the string.

Check constraints in SQL Server
25 May 2019

Check constraints in SQL Server

What is the check constraint in SQL Server, what is it used for and what is it used for? This article will give you the answer.

Index in SQL Server
25 May 2019

Index in SQL Server

This article explains how to create, rename and delete indexes in SQL Server.

Find Login in SQL Server
25 May 2019

Find Login in SQL Server

Are there any queries in SQL Server that return all login accounts and information about them?

New points in SQL Server 2017
25 May 2019

New points in SQL Server 2017

The SQL Server 2017 version is primarily connected to Linux, bringing the power of SQL to Linux. In short, you can install SQL Server 2017 on Linux, using SQL Server 2017 on