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 a callback c#?
What is the implicit name of the parameter that gets passed into the class set method?
What is the use of console application in c#?
What is Named parameter in C#?
Okay, so an int is a value type, and a class is a reference type. How can int be derived from object?
What is out int in c#?
When should I throw an exception?
What is append in c#?
Why do we use void in c#?
What do you mean by the delegate in c#?
How long does it take to learn c# for unity?
What is the use of readkey in c#?
what is be the overhead, if i use binary transmission. and will it be sent using xml text or how ?
Why do we use static class in c#?
What is a cs file?