MSSQL Create Unique Constraints Example to create a unique constraint on a column. ALTER TABLE tablename ADD CONSTRAINT CK_Columnname UNIQUE (Columnname)
MSSQL JOIN Selection Queries MSSQL Server / By Tim van Kooten Niekerk INNER JOIN: Only records with joing fields in both tables. LEFT OUTER JOIN: All records from table 1 and only matching fields from table 2…
MSSQL Create Table Partitions MSSQL Server / By Tim van Kooten Niekerk Instruction written in the Dutch language…