Static and Dynamic

Total Post:113

Points:791

 440  View(s)
Ratings:
Rate this:

What is Static and Dynamic SQL ?

  1. 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

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.