Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Have I been smoking something?? Insert construction question. RE: Have I been smoking something?? Insert construction question.

  • May 15, 2013 at 5:55 am

    #1615366

    Well in that case, you can simply provide the columns while inserting as well:

    insert into dbo.T(ColA, ColB) select 'xxx', 'yyy'

    or

    insert into dbo.T(ColB, ColA) select 'xxx', 'yyy'

    depending on whether you want 'xxx' to be inserted in ColA or ColB and same for 'yyy'. It's the basic insertion and SQL Server provides you all the approaches you want to insert data.