SP to alter table

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  November 4, 2008 at 10:20 am

  #200931

  Can i create a store proc where it does 44 alter column commands and add column cmd. As i had bad expreince running all alter column commands at once, I want to do it through SP where it runs each alter cmd, once finished run next alter cmd.

  is this possible? may be with CTE or anything else.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  November 4, 2008 at 10:57 pm

  #894059

  Yes, you can do this. However, you may need to separate the individual commands into separate batches by using Dynamic SQL invocations.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]