Server: Msg 207, Level 16,

In a Stored Procedure, I created a table in code:





CREATE TABLE TEMP ( ...)





, then ALTER TABLE TEMP ADD int1 int, varchar2 varchar(25)





I inserted some rows to the above table. Everything looks good.





Here's what puzzled me:





SELECT * FROM TEMP shows all the rows inserted.





But





SELECT int1, varchar2 FROM TEMP caused this error:





Server: Msg 207, Level 16, State 3, Line 5


Invalid column name 'int2'.


Server: Msg 207, Level 16, State 1, Line 5


Invalid column name 'varchar2'.





Thanks for any help.