SQL Server Archives - Page 6 of 14 - Adglob Infosystem Pvt Ltd

SQL Server: LEFT Functions

Post author:K Z
Post published:October 14, 2021
Post category:SQL Server
Post comments:3 Comments

This SQL Server tutorial explains how to use the LEFT functions in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the LEFT functions allows you to extract a…

SQL Server: LEN Function

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

This SQL Server tutorial explains how to use the LEN functions in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the LEN functions returns the length of the…

SQL Server: DATALENGTH Function

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

This SQL Server tutorial explains how to use the DATALENGTH function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the DATALENGTH function returns the length of an expression,…

SQL Server: + Operator

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

This SQL Server tutorial explains how to use the concatenate operator (+ operator) in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the + operator allows you to concatenate…

SQL Server: CONCAT Function

Post author:K Z
Post published:October 13, 2021
Post category:SQL Server
Post comments:4 Comments

This SQL Server tutorial explains how to use the CONCAT function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the CONCAT function allows you to concatenate strings…

SQL Server: CHARINDEX Function

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

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

SQL Server: CHAR Function

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

This SQL Server tutorial explains how to use the CHAR function in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the CHAR function is the opposite of the ASCII…

SQL Server: ASCII Function

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

This SQL Server tutorial explains how to use the ASCII functions in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server (Transact-SQL), the ASCII functions returns the NUMBER code that…

SQL Server: Unique Constraints

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

This SQL Server tutorial explains how to create, add, and drop unique constraints in SQL Server with syntax and examples. What is a unique constraint in SQL Server? A unique constraint is…

SQL Server: Sequences (Autonumber)

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

Learn how to create and drop sequences in SQL Server (Transact-SQL) with syntax and examples. Description In SQL Server, you can create an autonumber field by using sequences. A sequence is an…