Any USE statement in the dynamic SQL will not affect the calling stored procedure.
Temp tables created in the dynamic SQL will not be accessible from the calling procedure since they are dropped when the dynamic SQL exits.
The block of dynamic SQL can access temp tables created by the calling procedure.
The effect of SET command in the dynamic SQL lasts for the duration of the block of dynamic SQL only and does not affect the caller.
When using stored procedures, users do not need permissions to access the tables accessed by the stored procedure. This does not apply when you use dynamic SQL!
The query plan for the stored procedure does not include the dynamic SQL!!!
The block of dynamic SQL has a query plan of its own.
The first parameter @stmt of sp_executesql is Unicode - nvarchar/ntext. varchar is not valid!
No comments:
Post a Comment