MSSQL Remove All Table RowsBy Tim van Kooten Niekerk / MSSQL Server / 2009-06-04 TRUNCATE TABLE tablename
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 Unique Constraints MSSQL Server / By Tim van Kooten Niekerk Example to create a unique constraint on a column. ALTER TABLE tablename ADD CONSTRAINT CK_Columnname UNIQUE (Columnname)