work around cursor.rowcount not returning anything useful before 1st fetch with mssql (closes #1910869) use select count(*) from table to get the number of rows

if repo.system_source.dbdriver == 'postgres':
    sql('ALTER TABLE appears ADD COLUMN weight float')
    sql('UPDATE appears SET weight=1.0 ')