Answer Posted / 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.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Define MSIL, and how does it works? Why our developers need an appreciation of it if at all?
What is the difference between throw and throw ex?
Constructor to an arbitrary base constructor?
What is the purpose of dictionary in c#?
what is the difference between interface and multiple interface?
Why do we need delegates?
What is cshtml?
What are the different states of a thread?
What is the meaning of console writeline in c#?
What is datacontract in c#?
What is the C# syntax to catch any possible exception?
Describe the parts of assembly.
Name the two classes are required for implementing a windows service?
What is the difference between serialization and deserialization in c#?
What is yield return in c#?
