Add a Primary Key To Your SQL DB
It comes up from time to time where you have a DB you need to work with and you notice that some bastard didn’t put a PK on it.
Heres a quick way to wedge that in without too much fuss.
ALTER TABLE Accounts ADD ID int identity(1,1) not null
ALTER TABLE Accounts ADD CONSTRAINT pk_Accounts_ID primary key(ID)