MSSQL Quick Copy Table Quickly duplicate a table with the following query. SELECT * INTO newtable FROM table
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)