---
title: "Static and Dynamic"  
description: "Static and Dynamic"  
author: "Anonymous User"  
published: 2018-06-21  
updated: 2018-06-22  
canonical: https://www.mindstick.com/forum/34535/static-and-dynamic  
category: "mysql"  
tags: ["sql server", "sql", "sql update"]  
reading_time: 1 minute  

---

# Static and Dynamic

What is [Static](https://www.mindstick.com/articles/12098/the-static-keyword-the-static-methods) and [Dynamic SQL](https://www.mindstick.com/interview/623/what-is-dynamic-sql) ?

## Replies

### Reply by Prakash nidhi Verma

Differences between Static and [Dynamic](https://www.mindstick.com/blog/11080/features-of-java-dynamic-complied-and-interpreted) [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database):

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.


---

Original Source: https://www.mindstick.com/forum/34535/static-and-dynamic

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.