what is dynamic sql

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


Please Help Members By Posting Answers For Below Questions

Which string method is used for concatenation of two strings in c#?

455


What Happens In Memory When You Box And Unbox A Value-type?

444


What are satellite assemblies? How will you get the different language strings?

469


Why delegate is used in c#?

454


Explain About .NET Remoting and types of remoting

561






List some of the basic string operation?

486


What is the use of 'using' statement in c#?

466


Explain about ODP.net

791


What is readline library?

479


Can a static class have a constructor c#?

457


What is window application in c#?

482


What are the different types of classes in c#?

468


Can class be protected in c#?

496


What is difference between .net and c#?

447


Can we inherit partial class in c#?

478