Stack Overflow
Stack Overflow

Questions tagged [pymssql]

A discontinued interface for Python that provided a standard Python DB-API interface to Microsoft SQL Server.

Pymssql was an interface for Python that provided a standard Python DB-API (as defined by PEP 249) interface to Microsoft SQL server. It was discontinued in November 2019.

Related tags:

621 questions
-1
votes
1 answer

mysql query for a situation?

I have two tables, OrderTable(orderid,ordersum) and OrderPayments(orderid,paidamount). OrderTable orderid ordersum ORD123456 40,000.00 ORD789987 30,000.00 OrderPayments orderid paidamount ORD123456 10,000.00 ORD123456 …
Anil kumar Kun
  • 27
  • 8
-2
votes
1 answer

Tested SQL query not working in SQL Editor of Apache Superset

I am trying to create new dataset via SQL Labs Editor. I have SQL query which is working fine via database manager. However, if I try same query in SQL Lab on Apache Superset it is not working, giving the following error (database I use is Microsoft…
Lukas Kondrusevičius
  • 25
  • 3
-2
votes
1 answer

Adding New Database Drivers in Docker

I'm trying to install the driver pymssql according to the instruction: https://superset.apache.org/docs/databases/docker-add-drivers/ I didn't understand where to create the file requirements-local.txt. What is ./docker? When i do docker-compose…
Marina Vinograd
  • 45
  • 1
  • 6
-2
votes
1 answer

Issue installing pymssql on m1 Mac

8 warnings generated. clang -bundle -undefined dynamic_lookup -arch arm64 -arch x86_64 -Wl,-headerpad,0x1000 build/temp.macosx-10.14-arm64-3.8/src/pymssql/_mssql.o -L/opt/homebrew/opt/freetds/lib -lsybdb -lssl -lcrypto -o…
John Carter Maes
  • 11
  • 1
-2
votes
1 answer

Execute SQL Server stored procedure from python on database directly

I want to run an existing SQL Server stored procedure on a database using Python. To clarify, I do not want to get the output in Python. I want the output to be saved directly in the database itself. I connected to the database using pymssql using…
Levani Zandarashvili
  • 1
  • 1
-2
votes
1 answer

Write SQL Server query

Help me please with query: select * from sc84 as nom join sc319 as p on p.PARENTEXT = nom.id join sc219 as pt on p.sp327 = pt.id join _1SCONST as c on c.objid=p.id As a result approximately such table Car / price_base / 08-08-2016:13-40 / 100 /…
0xdeface
  • 259
  • 2
  • 11
1 2 3
…
41
42