title: How to create an insert view
body: <p>I have two SQL Server instances on the same PC, a default and a named instance. I have to perform primary horizontal fragmentation. My database has 4 tables I have to fragment the tables on the basis of some conditions. I create a linked server and created a view that takes data from table from both instances and combines them into one view (database and tables on both instances are same/schema is same).</p>
  
  <p><a href="https://i.stack.imgur.com/64z2r.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/64z2r.jpg" alt="View taking data from two instances]"></a></p>
  
  <p>Query in view</p>
  
  <p><a href="https://i.stack.imgur.com/CEsNw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CEsNw.png" alt="Query in View"></a></p>
  
  <ol>
  <li><p>I want to write an insert view that inserts values in my first view, as first view returns data from two tables</p></li>
  <li><p>I want to create a trigger for insert view when value is added in insert view trigger condition is checked and processed data in different tables as accordingly the condition let's say I want the data <code>where Semester &gt; 5</code> in instance 1 (default instance) and <code>where Semester &lt;= 5</code> must be stored in instance 2 (named instance).</p></li>
  </ol>