title: Insert bulk data using Openrowset
body: <p>I need to insert datas from a table of database A into another table belonging to the database  B. using Openrowset concept</p>
  
  <pre><code>INSERT INTO TableName
      SELECT * 
      FROM OPENROWSET(BULK 'SQLNCLI', 'Server=(local);Trusted_Connection=yes;',
                           'SELECT Columns FROM ``Database.Schema.Tablename ORDER BY columns)
  </code></pre>