K Z, Author at Adglob Infosystem Pvt Ltd

SQL Server: SIGN Function

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the SIGN function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the SIGN functions returns a value indicating the…

SQL Server: RAND Function

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:2 Comments

This SQL Server tutorial explains how to use the RAND function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the RAND function can be used to return…

SQL Server: ROUND Function

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the ROUND function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Servers (Transact-SQL), the ROUND function returns a number rounded to…

SQL Server: FLOOR Function

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the FLOOR function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the FLOOR functions returns the largest integer value…

SQL Server: CEILING Function

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the CEILING function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the CEILING functions returns the smallest integer value…

SQL Server: AVG Function

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the AVG function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the AVG function returns the average value of…

SQL Server: ABS Function

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the ABS function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the ABS function returns the absolute value of…

SQL Server: GOTO Statement

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:0 Comments

This SQL Server tutorial explains how to use the GOTO statement in SQL Server (Transact-SQL) with syntax and examples. Description The GOTO statement causes the code to branch to the label after…

SQL Server: FOR LOOP

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:0 Comments

Learn how to simulate the FOR LOOP in SQL Servers (Transact-SQL) with syntax and examples.TIP: Since the FOR LOOP does not exist in SQL Server, this page describes how to simulate a FOR…

SQL Server: WHILE LOOP

Post author:K Z
Post published:October 16, 2021
Post category:SQL Server
Post comments:1 Comment

This SQL Server tutorial explains how to use the WHILE LOOP in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server, you use a WHILE LOOP when you are not…