Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. set conn = server.CreateObject("ADODB.Connection")
  2. conn.ConnectionTimeout=120
  3. conn.Open("Provider=sqloledb;Data Source=(local);Initial Catalog=myDatabase;Integrated Security=SSPI")
  4.  
  5. sql = "update myTable set zipCode = 91839 where ID = 12345"
  6. conn.execute(sql)
  7.  
  8. sql = "update myTable set zipCode = 02930 where ID = 67890"
  9. conn.execute(sql)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement