title: Get Insert query with already inserted data from a table based On certain Conditions
body: <p>I have a table named <code>sampletable</code> </p>
  
  <p>and it has 10000 rows and i want to generate script (Insert query with inserted data) for this table based on certain conditions.</p>
  
  <p>That is i need the insert query with data  for certain conditions </p>
  
  <p>like <code>select * from sampletable where id=10</code> something like that </p>
  
  <p>The select query will results 100 rows only so i need to get only this 100 rows as insert query statement with inserted values</p>
  
  <p>I had tried </p>
  
  <p><code>Sql Management Studio</code> <strong>Generate Script methods</strong> but it results all rows.
  I don't know how to do this please help me to solve this .</p>
  
  <p>My purpose is i need to take backup of the  data (Only the Specific condition data not all)</p>