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

GeekInterview.com > Interview Questions > Database > Stored Procedures

Go To First | Previous Question | Next Question

Stored Procedures | Question 8 of 12

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

Total Answers and Comments: 3

Last Update: May 26, 2008 Asked by: asd3

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 17, 2007 17:22:41

mike

RE: What is the difference between "stored procedure" ...

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

Is this answer useful? Yes | No

March 10, 2008 03:43:52

sampra

Member Since: February 2008 Contribution: 279

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

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

Is this answer useful? Yes | No

May 26, 2008 23:30:11

krishnaindia2007

Member Since: September 2007 Contribution: 870

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

Stored procedures are stored in data base in complied form. In dynamic sql the statements are dynamically constructed at run time.

Is this answer useful? Yes | No