开发者

Generate scripts SQL Server 2008

开发者 https://www.devze.com 2023-02-05 06:59 出处:网络
I would like to generate scripts of about 100 Stored Procedures. When I generate script, all the files contains \'CREATE PROCEDURE\' statement. How should I get scripts with \'ALTER PROCEDURE\' statem

I would like to generate scripts of about 100 Stored Procedures. When I generate script, all the files contains 'CREATE PROCEDURE' statement. How should I get scripts with 'ALTER PROCEDURE' statement?开发者_高级运维


  • Find/replace in an editor
  • Script with a DROP first
  • Use a 3rd party to generate a differential script instead


If you generate all the scripts to a new query window you could press Ctrl-Shift-H to get the find and replace in files dialog up and do a finf and replace on 'CREATE PROCEDURE' to 'ALTER PROCEDURE'?

0

精彩评论

暂无评论...
验证码 换一张
取 消