If you are like me, who got used to modifying stored procedures by right-clicking and clicking modify and if you had tinkered around the scripting options, then you will find it confusing that suddenly sp_executesql seems to appear in the script and not the normal one.
Wonder why?
This will happen if you make IF NOT EXISTS option to be true.
This will cause management studio to display the script on modify or script new to be using sp_executesql syntax.
Turn IF NOT EXISTS option to false, and you will be fine.
No comments:
Post a Comment