title: How to write a stored Procedure for deleting multiple rows in SQL Server 2005
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/337704/parameterizing-a-sql-in-clause">Parameterizing a SQL IN clause?</a>  </p>
  </blockquote>
  
  
  
  <p>I need to delete a multiple rows in a sql table from asp.net in a single click.How to write a stored procedure for this? but i should use "IN" keyword so that i can delete multiple rows at a time.so if i create a SP containing delete query with "IN" keyword, in what format should i pass the input parameter?</p>