且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用 sp_executesql 阻止 SSMS 编写 SP 脚本?

更新时间:2022-05-03 22:18:23

关闭Include IF NOT EXISTS"选项.

Turn off the "Include IF NOT EXISTS" option.

它位于工具...选项,然后在弹出的对话框的资源管理器窗格中单击脚本".IF NOT EXISTS"选项位于自上而下的第二组(对象脚本选项).

It's at Tools..Options, then click "Scripting" on the explorer pane of the dialog that pops-up. the "IF NOT EXISTS" option is in the second group from the top (Object Scripting options).