Posted by Franco Falkov June-21-2018 22:34 PM SQL Server SQL SQL Update MYSQL 1 Reply(s) 566 View(s) Ratings: Rate this: What is Static and Dynamic SQL ?
Prakash nidhi Verma Re: Static and Dynamic Posted on one year ago 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.
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.