Guest User

Untitled

a guest
Mar 6th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. import pymssql
  2.  
  3. server = 'ip'
  4. username = 'user'
  5. password = 'pswrd'
  6.  
  7. cnxn = pymssql.connect(server, username, password, "tempdb")
  8. cursor = cnxn.cursor()
  9.  
  10. query = "SELECT "TIME_A", "TIME_B", "NAME", "NAME_B", SOMETHING, SOMETHINGMORE, "GROUP ALPHA"
  11. FROM "DATABASE"."db"."SUBDATABASE"
  12. WHERE "GROUP ALPHA"='PEOPLE A'
  13. OR "GROUP ALPHA"='PEOPLE B'
  14. OR "GROUP ALPHA"='PEOPLE C'
  15. OR "GROUP ALPHA"='PEOPLE D'
  16. OR "GROUP ALPHA"='PEOPLE F'
  17. OR "GROUP ALPHA"='PEOPLE E' ";"
Add Comment
Please, Sign In to add comment