Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function AcessaVendas () {
- var URL = 'jdbc:sqlserver://servername:49159'
- var USER = 'visitant'
- var PASS = '*******'
- var conn = Jdbc.getConnection(URL, USER, PASS);
- var stmt = conn.createStatement();
- stmt.setMaxRows(10000);
- var start = new Date();
- var rs = stmt.executeQuery( myquery());
- var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Dados");
- ss.getRange('a2:h1000').clearContent();
- var cell = ss.getRange('a2');
- var row = 0;
- while (rs.next()) {
- for (var col = 0; col < 11; col++) {
- cell.offset(row, col).setValue(rs.getString(col + 1));
- }
- row++;
- }
- rs.close();
- stmt.close();
- conn.close();
- var end = new Date();
- Logger.log('Time elapsed: ' + (end.getTime() - start.getTime()));
- }
- db = "databasename"
- URL = 'jdbc:mysql://servername:49159'+'/'+ db;
Add Comment
Please, Sign In to add comment