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 variable and its classification?
Does c# have primitives?
What is difference between destructor and finalize?
What is interface used in c#?
What is before string in c#?
What are value types and reference types?
What is deadly diamond problem?
Is stringbuilder thread safe c#?
How to generate strong name key file or which command is used to generated strong name key file?
How will you deploy the dll file in gac?
Give some examples of commonly used i/o classes?
What is the use of table aliases?
What are the Configuration files in .net?
Difference between type constructor and instance constructor? What is static constructor, when it will be fired? And what is its use?
Are enums static c#?
