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

—

Submitted by: krishnaindia2007

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

Above answer was rated as good by the following members:
ibrarx, bpalkannan, sandeep549

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: 278

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: 854

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

3 0

Overall Rating: +3

Go To Top

User Name		Remember Me?
Password

Question Bank