Qus:    what is the diff between custom and dynamic sql services? provide a detailed explanation
Jan 21, 2014 15:08 1 Answers Views: 2432 Hawk
Prev Next
Answers (1)
Hawk Jan 21, 2014 15:08
Answer:  

Custom SQL and Dynamic SQL we have to write the queries explicitly.The main difference between Custom SQL and Dynamic SQL is, in Custom SQL we can give the input values at design time. In Dynamic SQL we can give the input values at run time.


By using custom SQL, one can execute any static SQL statements but by using dynamic we can able to execute only input field which query you set.


In CustomSQL, you can pass inputs to your SQL query at runtime. With DynamicSQL, you can pass your entire SQL statement, or part of your SQL statement (like the where clause) can be passed at runtime; along with inputs to it. In simple words, with dynamicSQL you can dynamically build your SQL statement at runtime.


Customizing The SQL QUERY is fixed with input variable that are passed to the custom adapter service. But in runtime you use dynamic SQL if SQL query changes during the runtime in this cases you prepare the sql query and pass it to dynamic adapter service in the runtime.


Post Your Answer
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect