data order changed when insert data into sql server

[ryjfgjl]

`
import pandas as pd
import pyodbc
file = r'C:\Users\ryjfgjl\Desktop\test.xlsx'

dataset = pd.read_excel(file, dtype=str, sheet_name='Sheet1', na_filter=False, header=4)
dataset.fillna(value='', inplace=True)
print(dataset['CARDNO'].values.tolist())
datalist = dataset.values.tolist()
odbc_conn_str = rf"DRIVER=ODBC Driver 18 for SQL Server;SERVER=localhost;"
rf"DATABASE=test;"
rf"UID=;PWD=;"
rf"Trusted_Connection=yes;Encrypt=no;LongAsMax=no;"
db_connection = pyodbc.connect(odbc_conn_str
, autocommit=True, charset='utf8')
cursor = db_connection.cursor()
cursor.execute('truncate table dbo.test')
s = '?,'*41
s = s[:-1]
for idx, row in enumerate(datalist):
row = row[:41]
cursor.execute(f'insert into dbo.test values({s})', row)
`
The data in excel read looks like:

The data in sql server after insert:

The data order changed

[gordthompson]

See the answer to this Stack Overflow question. Essentially,

Unless your select has an ORDER BY clause the order it is returned is random and can change even between two calls.