SQL Server

The article will give you detailed instructions on how to use the SQL Server ROUND () function with the syntax and specific examples to make it easier to visualize and capture the

The SIGN function in SQL Server is used to retrieve the sign of a number or the transmitted expression.

The SQL Server SUM function returns the total value of a column, a data set, or an expression.

The SQL Server CURRENT_TIMESTAMP function returns the current date and time, in the format 'yyyy-mm-dd hh: mi: ss.mmm'.

The DATENAME function in SQL Server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... The return value is a

This article will show you in detail how to use SQL Server's datetime DATEDIFF () function with syntax and specific examples to make it easier to visualize and capture functions.

The DATEADD function in SQL Server returns a new time value when it is added a specified time period.

The DATEPART function in SQL Server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... The return value is an

Like other programming languages, SQL Server also provides users with an IF command EL .... The article will detail how to use the syntax and clear examples to make it easier for

The Break command used to exit the loop does not specify a stop condition or you want to stop the loop on condition that you specify and execute the statements following the loop

The CONTINUE command is used to give command execution authority to the last expression of the loop. That means upside-down to the top of the loop, all the commands that follow in

The GOTO command is a simple jump command, which allows an unconditional jump program from GOTO to a location in the program that has a label (laber) command in the same function.

On September 24, Microsoft announced the release of SQL Server 2019 Community Technical Preview (CTP) 2.0. It is very suitable for database professionals to keep up with modern

The WHILE loop is used if you want to run a code repeatedly when the given condition returns TRUE. Let's find out how to use WHILE in SQL Server with Network Administrator.

The FOR loop is often used to run a code repeatedly for the number of repetitions. However, in SQL Server there is no FOR loop.

The article will explore and guide you how to use the ASCII () function in SQL Server.

CHAR function in SQL Server is used to convert an integer expression into the corresponding character in ASCII code.

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

Learn how to use the CONCAT () function in SQL Server to join two or more strings into a string.

Learn how to use the + operator in SQL Server to join two or more strings into a string.