clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591646 fiddles created (45707 in the last week).

CREATE TABLE VarcharClustered ( ID INT ,Name VARCHAR(2000) )
 hidden batch(es)


CREATE CLUSTERED INDEX idx_VarcharClustered_Name ON VarcharClustered(Name)
Warning! The maximum key length for a clustered index is 900 bytes. The index 'idx_VarcharClustered_Name' has maximum length of 2000 bytes. For some combination of large values, the insert/update operation will fail.
 hidden batch(es)


INSERT INTO VarcharClustered VALUES (1,REPLICATE('a',1701))
Msg 1946 Level 16 State 3 Line 1 Operation failed. The index entry of length 1701 bytes for the index 'idx_VarcharClustered_Name' exceeds the maximum length of 900 bytes for clustered indexes.
 hidden batch(es)


INSERT INTO VarcharClustered VALUES (1,REPLICATE('a',1700))
Msg 1946 Level 16 State 3 Line 1 Operation failed. The index entry of length 1700 bytes for the index 'idx_VarcharClustered_Name' exceeds the maximum length of 900 bytes for clustered indexes.
 hidden batch(es)


INSERT INTO VarcharClustered VALUES (1,REPLICATE('a',901))
Msg 1946 Level 16 State 3 Line 1 Operation failed. The index entry of length 901 bytes for the index 'idx_VarcharClustered_Name' exceeds the maximum length of 900 bytes for clustered indexes.
 hidden batch(es)


INSERT INTO VarcharClustered VALUES (1,REPLICATE('a',900))
1 rows affected
 hidden batch(es)