add_id_column_to_existing_sql_table

This is just a handy SQL tip I putting here more for myself than anything. Say you have a table of data but want to add a ID column for a variety of uses. Just open up a query window and run the following:

use database

alter table dbo.Table add ID int identity