title: How to select object_definition(object_id) for table in sql using C#?
body: <p>I have 2 question.</p>
  
  <p>This query is for display script store procedure as create to query </p>
  
  <p>Query :</p>
  
  <pre><code>  Select object_definition(object_id) from sys.objects
    where type_desc in ( 'SQL_STORED_PROCEDURE') 
  </code></pre>
  
  <p>I can display script of all store procedure.</p>
  
  <p>Question 1 : I have TestStoreProcedure in store procedures.How can I display for only TestStoreProcedure.How can I use like this :</p>
  
  <pre><code>    Select object_definition(object_id) from sys.objects
    where type_desc in ( 'SQL_STORED_PROCEDURE')  and ??? =TestStoreProcedure 
  </code></pre>
  
  <p>Question 2 : How can I use this query for tables or for defined table ?</p>