Static and Dynamic

Total Post:113

Points:791
 205  View(s)
Ratings:
Rate this:

What is Static and Dynamic SQL ?

  1. Post:140

    Points:984
    Re: Static and Dynamic

    Differences between Static and Dynamic SQL:

    STATIC SQL :  

    - it's application do not change at runtime.

    - the application may allow users to enter their own queries.

    - predetermined data

    - It is more swift and efficient.

    - statements are compiled at compile time.

    - It is less flexible.

    - can be hard-coded into the application.

    DYNAMIC SQL : 

    - it's application constructed dynamiacally at run time.

    - determined data at run time.

    - It is less swift and efficient.

    - statements are compiled at run time.

    - It is more flexible.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!