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 private static in c#?
What is the solution if you need to manipulate sets of items?
What are the types of attributes in c#?
What issues can be faced while delivering code?
You are creating a custom usercontrol, some of the newly created properties are shown in the properties window. How you can hide a new property named theme from the properties window?
How do you create empty strings in c#?
What is the difference between an application domain and a process?
What does console mean c#?
What is delegation in oops?
What is foreach loop in c#?
Is array reference type in c#?
What is difference between const and static in c#?
What is difference between list and dictionary in c#?
Why extension method is static?
How do you sort an array in c#?