EXEC and sp_executesql

pts.
Tags:
SQL Server
Standard Edition 2000
Could someone give me a concise summary of the differences between EXEC and sp_executesql? Should we set standards that require the use of one over the other by our developers? Cheers

Answer Wiki

Thanks. We'll let you know when a new response is added.

EXEC runs a procedure within another procedure. This can also be used to execute dynamic SQL.

sp_executesql allows you to run dynamic SQL within a batch or procedure. sp_Executesql allows you to pass in variables to the dynamic code, as well as pass values back from the dynamic code.

Each has thier use and I won’t recommend forcing one or the other.

<b>Differnece between sp_executesql and exec</b>

exec compiles the code every time and then execute but sp_executesql executes the code without recompiling it.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following