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
What is c# windows form application?
Define Final Class in C#
I want to print "Hello" even before main() is executed. How will you achieve that?
What is a function c#?
Which of the following API is used to hide a window?
Why do we override in c#?
How much time will it take to learn unity?
What is asynchronous one-way calls?
How do I declare inout arguments in c#?
If a class derives from another class, will the derived class automatically contain all the public, protected, and internal members of the base class?
Why do we use inheritance in c#?
Can you inherit from a sealed class?
How many parameters can a method have c#?
Why do we need constructor?
Which are the loop types available in c#?