SQL Snippets

Column Changes


ALTER TABLE Customer ADD isActive BIT NOT NULL DEFAULT 1
GO

Create table from Select (MySQL)


CREATE TABLE new_table_name AS
    SELECT column1, column2,...
    FROM existing_table_name
    WHERE ....;

Awesome references