RE: Using alter command in Stored Procedure

SSC Guru

Points: 323504

July 29, 2009 at 5:03 pm

#1032076

you need to either built your table with all it's columns, or use the EXEC(@sqlstatement) to do the alter an iupdate.

the database engine expects either a GO statement, so it knows the ALTER command is completed, so that it is commited to the metatadata.

the best solution build the whole thing in one pass:

select Table1.*,'Yes' As [Edit]

into Table2

from Table1

where date > '07/01/2009'

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!