add column in certain position

  • I built something like this once... took me a month (was in a bigger project).

    If I were you I would not waste time on this matter. SSMS is the safest / fastest way to do this. Let them figure out all the details and concentrate on something more important 😉

  • :satisfied:

    roger that 😉

  • HI,

    What is the importance of colum Order in writinig selec queries in your application!! If you are looking for "C" column in between "B" & "D" then have this placing as part of your SELECT statement.

    Thanks -- Vj

    http://dotnetvj.blogspot.com

  • If it is for the reasons of an external SQL generator, can you substitute actual columns order by using extended properties on the columns?

    This way, your solution will be flexible and dynamic.

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply