1.query all the store procedures in the specfied db;
use MyDB select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='procedure'
2.create proc with while loop
create proc BatchInsertYearSalary as declare @year int declare @nowYear int declare @salary money begin set @year=2011 set @nowYear=YEAR(GETDATE()) set @salary=10 while(@year<=@nowYear) begin insert into dbo.YearSalary values(@year,@salary); set @year=@year+1 set @salary=@salary+10 end end
原文链接: https://www.cnblogs.com/Fred1987/p/11486561.html
欢迎关注
微信关注下方公众号,第一时间获取干货硬货;公众号内回复【pdf】免费获取数百本计算机经典书籍;
也有高质量的技术群,里面有嵌入式、搜广推等BAT大佬
原创文章受到原创版权保护。转载请注明出处:https://www.ccppcoding.com/archives/402175
非原创文章文中已经注明原地址,如有侵权,联系删除
关注公众号【高性能架构探索】,第一时间获取最新文章
转载文章受原作者版权保护。转载请注明原作者出处!