How to insert a not null column in an existing table with records..?

Either assign a DEFAULT value to the column, or make it nullable to start with, populate the column and then alter it to NOT NULL