Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymssql
- server = 'ip'
- username = 'user'
- password = 'pswrd'
- cnxn = pymssql.connect(server, username, password, "tempdb")
- cursor = cnxn.cursor()
- query = "SELECT "TIME_A", "TIME_B", "NAME", "NAME_B", SOMETHING, SOMETHINGMORE, "GROUP ALPHA"
- FROM "DATABASE"."db"."SUBDATABASE"
- WHERE "GROUP ALPHA"='PEOPLE A'
- OR "GROUP ALPHA"='PEOPLE B'
- OR "GROUP ALPHA"='PEOPLE C'
- OR "GROUP ALPHA"='PEOPLE D'
- OR "GROUP ALPHA"='PEOPLE F'
- OR "GROUP ALPHA"='PEOPLE E' ";"
Add Comment
Please, Sign In to add comment