Author: K Z

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…

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…

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…

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…

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…

Learn how to create and drop procedures in SQL Server (Transact-SQL) with syntax and examples. What is a procedure in SQL Server? In SQL Server, a procedure is a stored program that…

This SQL Server tutorial explains how to use literals (strings, integers, decimals, and datetime values) in SQL Server with examples. Description In SQL Server, a literal is the same as…

Learn how to create, rename and drop indexes in SQL Server with syntax and examples. What is an Index in SQL Server? An index is a performance-tuning method of allowing faster retrieval…

Learn how to grant and revoke privileges in SQL Server (Transact-SQL) with syntax and examples. Description You can GRANT and REVOKE privileges on various database objects in SQL Server. We'll look at…

Learn how to create and drop functions in SQL Server (Transact-SQL) with syntax and examples. What is a function in SQL Server? In SQL Server, a function is a stored program that…