Question: what is the difference between custom sql and dynamic sql in webmethods?
Answer: 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.