1 Reply Latest reply on May 5, 2017 7:07 AM by Zhouyi Zhang

    Call the parameters dynamically

    sunil kumar

      Hi

       

      I am using store procedure from SQL server and I am unable to call the parameters dynamically. Actually I am having 5 parameters in which two of them are date parameters and others are strings, and I would like to know whether a stored procedure is better or a direct custom query is better for the performance.

        • 1. Re: Call the parameters dynamically
          Zhouyi Zhang

          Hi, Sunil

           

          Your question is very general query, the solution may be various depend on many situation. e.g. if the execution of SP is just in seconds and return a small data set, then live connect may be a good option. While if the SP takes minutes to run, probably using custom query and extract data regularly is a better solution. So it really depends on your demand and leverage with your system basis.

           

          ZZ