Answer / hima

Dynamic SQL is a term used to mean SQL code that is
generated programatically (in part or fully) by your program
before it is executed. As a result it is a very flexible and
powerful tool. You can use dynamic sql to accomplish tasks
such as adding where clauses to a search based on what
fields are filled out on a form or to create tables with
varying names.
Using dynamic SQL you can put a SQL statement inside a
variable and execute that statement. It's what you have to
do when you're trying to run Select * from @TableName.

Answer / nilesh

Dynamic SQL enables you to write programs that reference
SQL statements whose full text is not known until runtime.
Before discussing dynamic SQL in detail, a clear definition
of static SQL may provide a good starting point for
understanding dynamic SQL. Static SQL statements do not
change from execution to execution. The full text of static
SQL statements are known at compilation, which provides the
following benefits:

Successful compilation verifies that the SQL statements
reference valid database objects.
Successful compilation verifies that the necessary
privileges are in place to access the database objects.
Performance of static SQL is generally better than dynamic
SQL.
Because of these advantages, you should use dynamic SQL
only if you cannot use static SQL to accomplish your goals,
or if using static SQL is cumbersome compared to dynamic
SQL. However, static SQL has limitations that can be
overcome with dynamic SQL. You may not always know the full
text of the SQL statements that must be executed in a
PL/SQL procedure. Your program may accept user input that
defines the SQL statements to execute, or your program may
need to complete some processing work to determine the
correct course of action. In such cases, you should use
dynamic SQL.

When do you absolutely have to declare a class as abstract (as opposed to free-willed educated choice or decision based on UML diagram)?

1 Answers  

---

Do we get an error while executing the “finally” block in c#?

0 Answers  

---

What is thread safe in c#?

0 Answers  

---

What is the difference between string and string in c#?

0 Answers  

---

Hai, I want to open a new form while the previous form is hiding or closing. I tried this with using MDI.I created one form like ParentForm.placed one button control.when clicked one that it opend new form like ChildForm.When i set the property of ChildForm to Maximize,but the ParentForm button control also appearing on the childform. so plz help me how to hide parentform controls(hide parentform while it is childform opened) thanq..

1 Answers  

---

What are partial types in c#?

0 Answers  

---

Can abstract class have constructor in c#?

0 Answers  

---

7. C# provides a default constructor for me. I write a constructor that takes a string as a parameter, but want to keep the no parameter one. How many constructors should I write?

2 Answers  

---

How long will it take to learn c#?

0 Answers  

---

What is type cast in C#?

0 Answers   TryTechnicals Pvt Ltd,

---

What is difference between ienumerable and list?

0 Answers  

---

What is hashset c#?

0 Answers  

---