title: Please tell me difference between running query directly and executing it using exec
body: <p>Please tell me what is difference
  ==> if i write query directly in storedprocedure 
  ==> and write query in string variable and than run it in exec  in stored procedure.</p>
  
  <p>i am using ms sql server 2005</p>