title: INSERT INTO database from another database, specifying some values in SQL Server
body: <p>I've researched about this but haven't found a particular solution for this case.
  I have two tables, each one in a different databases. </p>
  
  <p>Let's say they are <code>DB1.T1</code> and <code>DB2.T2</code>.</p>
  
  <p>From <code>DB1.T1</code> I want to select all rows from two specific columns <code>ID</code> and <code>Description</code>.</p>
  
  <p><code>DB2.T2</code> has the same two columns but also three additional columns: <code>T2.ID</code>, <code>Enable</code>, <code>Date</code>.</p>
  
  <p>Some considerations. DB2.T2 is a SQL Server, I've always worked with MySQL but this SQL Server had some inconsistencies from my previous experiences. The AUTOINCREMENT default condition didn't exist, and also the insert of default timestamp or date value when new record is created was not available.</p>
  
  <p>From my research I've come to some kinda solution that would be</p>
  
  <pre><code>INSERT INTO DB2.T2(ID, Description, Enable, Code ,Date)
      SELECT ID, Description 
      FROM DB1.T1;
  </code></pre>
  
  <p>BUT how can I add the three remaining columns?</p>
  
  <p>I was thinking to do some while loop and insert the increment as ID for DB2.T2 using the allowed <code>GETDATE()</code> function, but I'm not sure how to do it right away.</p>
  
  <p>Can I use the previous syntax of select INTO and also use INSERT INTO to do something like this?</p>
  
  <pre><code>INSERT INTO DB2.T2(ID, Description, Enable, Code, Date) 
  VALUES (index,?,1,?,GETDATE())
  </code></pre>
  
  <p>I'm really confused right now. I hope you can get what I'm trying to explain.</p>
  
  <p>Beside exporting data from one table to another, I want to insert additional data to the remaining columns. For enable I want it to be always 1, and the date the current date, The ID has to be a number and must be incrementing according to the row. </p>
  
  <p>What do you recommend to do? </p>
  
  <p>Meanwhile I'll keep my self trying to find similar solutions to this problem.</p>
  
  <p>Thanks in advance. :)</p>
  
  <p>Additional data. I'm working by VPN on a remote connection, all I've got is some sort of the cmd interface to insert and work with the DB. There are like 20000 rows, and importing exporting by CSV using bulk seems pretty strange to me.</p>