# coding: utf-8
import pyodbc
import random
import time
dsn = 'sqlserverdatasource'
server = 'SERVERNAME'
user = 'USER_NAME'
password = 'PASSWORD'
database = 'SM'
Namevartest ='MSP_RPist'
cnsn = pyodbc.connect('DSN=%s;UID=%s;PWD=%s;DATABASE=%s;'%(dsn,user,password,database))
cursor = cnsn.cursor()
#SQLCommand = "INSERT INTO [dbo].[test]([faceID],[userName],[dateregis]) VALUES ('test888-777-1859"+repr(random.randint(0,999))+"',"+repr(Namevartest)+",CONVERT(DATETIME,SYSDATETIMEOFFSET() AT TIME ZONE 'China Standard Time'))"
cursor.execute("INSERT INTO [dbo].[test]([faceID],[userName],[dateregis]) VALUES ('test888-777-1859"+repr(random.randint(0,999))+"',"+repr(Namevartest)+",CONVERT(DATETIME,SYSDATETIMEOFFSET() AT TIME ZONE 'China Standard Time'))"
)
cnsn.commit() #hen IMPORTANT
cursor.execute("select * from [dbo].[test]")
row = cursor.fetchone()
while row:
    print(str(row[0]))
    row=cursor.fetchone()