CONSTRAINT Archives - SQLServerGeeks

SQL Server– Unique Constraint VS Unique Index

September 17, 2016October 27, 2016 - by Sandip Pani - Leave a Comment

Both enforces uniqueness of the column. When we define an Unique constraint, SQL server creates an unique index (Unique non clustered index) on the column where Unique constraint is defined. Even though …

SQL Server / SQL Server Accidental DBA Series

Constraint to limit VARCHAR max character length in SQL Server

April 4, 2015December 20, 2019 - by SQL Geek - 1 Comment

A business need may arise to limit a VARCHAR column to a certain length. Consider a scenario where in an application has a 10000 character limit for a column. The VARCHAR(max) …