Example for creating SQL script from a templat in Ruby

DropSPs.rb

require 'fileutils'
require 'erb'

template = ERB.new <<-EOF
  IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'<%= sp_name %>') AND type in (N'P', N'PC'))
  DROP PROCEDURE <%= sp_name %>
  GO

EOF

File.readlines('sps_to_delete.txt').each do |line|
  sp_name = line.chomp
  puts template.result(binding)
end