Category Archives: sql

SQL – Unique Indexes Table of content SQL Unique Indexes The SQL Unique Index ensures that no two rows in the indexed columns of a table have the same values (no duplicate values allowed). A unique index can be created on one or more columns of a table using the CREATE UNIQUE INDEX statement in […]

SQL – Non-Clustered Index Table of content SQL Non-Clustered Indexes The SQL Non-Clustered index is similar to the Clustered index. When defined on a column, it creates a special table which contains the copy of indexed columns along with a pointer that refers to the location of the actual data in the table. However, unlike […]

SQL – Injection Table of content If you take a user input through a webpage and insert it into an SQL database, there is a chance that you have left yourself wide open for a security issue known as the SQL Injection. This chapter will teach you how to help prevent this from happening and […]