Execute Query

Question

Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp? 
 I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement? 
 Can anyone please help?

ravis · Answer

Hi, 
 You can run your query but your output will be exported in the Excel sheet. For this you can use "Export SQL To Excel" smart service. Thank You.

Mike Schmitt · Answer

Can you explain what your use case is that you can't use the standard Query Entity query? 
 In any case, you could always look into the Query Database Smart Service , though I personally really dislike it and only use it when absolutely necessary (which is very rarely, in my experience).