SQLTeam.com | Weblogs | Forums

How to add a new column to the end of a table using a stored procedure

I have a stored procedure in sql server. In that stored procedure, I have a query that I use to get data from another table, call it table A. My end goal through the stored procedure is to use this query to insert data into another table, call it table B. I want to add an additional column into table B, and that column already exists in table A.

My initial plan was to just enter the additional columns name into the query that I have in the stored procedure. Or should I use the ALTER TABLE clause. Or is there another special way to do this when I'm working with a stored procedure. I'd appreciate any help with this.



1 Like