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