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