What is the difference between "stored procedure" and "dynamic SQL" ?

  • Interview Candidate
  • 9
  • 6980

Showing Answers 1 - 9 of 9 Answers

mike

  • Jul 17th, 2007
 

Stored Procedures are compiled and runs on the server. dynamic SQL are not compiled and runs on client. 

  Was this answer useful?  Yes

sampra

  • Mar 10th, 2008
 

Stored Procedures are compiled and runs on the server. dynamic SQL are not compiled and runs on client.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions