What is the difference between exec and execute

It does not support it because Run reads the exit code that is released only when an external application exits. With this, ipconfig will be executed in command prompt. The CMD prompt will not be shown 0 and our script will wait till the program exits before it continues processing True. If we want to call explorer. Use Run instead. Active Oldest Votes. Use PDO::query to issue one-off non-prepared statements that return result sets.

That coupled to the fact their flexibility is seldom needed means that it's often preferred to: Use PDOStatement::prepare and PDOStatement::execute to prepare statements and execute them, regardless of whether they return results or not.

Also doesn't require additional tooling to handle statement construction. Almost always recommended whenever possible. Disclaimer: Only interpreting the docs, not a frequent user anymore. Improve this answer. Make sense? Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. Podcast The first ten years of our programming lives. Upcoming Events. Featured on Meta. Now live: A fully responsive profile. Candidate changes in Moderator Election — review your ballot. Linked Related They are the same. It is always good practice to use EXEC before stored procedure name even though SQL Server assumes any command as stored procedure when it does not recognize the first statement.

I am using entity framework , with same page somewhere i am using SP, SP takes too much time compare to Entity framework. Perhaps your joins are doing too much work? Perhaps you are missing one or more indexes? Computed columns implemented by User-Defined Functions can be very expensive.