Guest User

Untitled

a guest
Aug 2nd, 2016
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. puts "start..."
  2. require 'tiny_tds'
  3. client = TinyTds::Client.new username: 'sa', password: '123***s', host: '192.168.1.215', port: 1433, database: 'alyamama'
  4. #results = client.execute("SELECT * FROM motif_controle")
  5. #puts results.fields
  6. #results.each do |row|
  7. # puts row
  8. #end
  9. #puts "---------------"
  10. results = client.execute("EXEC sp_test")
  11. #results.do
  12. results.each do |row|
  13.  
  14. puts row.values_at("CodeMotif")
  15. puts row.values_at("Description")
  16.  
  17. end
Add Comment
Please, Sign In to add comment