I have a stored procedure which I'm building a temporary table (# table). I add an id column to the table by the alter table statement. I then try to select this column. When I do, I get an error column does not exist. But if I select * I can see the column.