Assuming user class:
User.connection.execute(“exec myproc.sp ‘param’”)
So basically, just like you would in any other language. However, I’d bury this.
class User < ActiveRecord::Base
def self.myproc(param) self.connection.execute(“exec myproc ‘#{param}’”) end
end
That way you can call
User.myproc(“something”)
When you call that, you get back a Mssql::Result class. You’ll need to look at the api docs to figure out how to retrieve records, but it’s basically a collection (think array)