python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Concatenates the values of string expressions in azure synapse serverless pool
I would like to write a query in serverless pool for concatenation of string values from multiple rows into single row with comma separated values. I am getting below error when I use COALESE functio...
Pakard
Votes: 0
Answers: 1
Allocate unique codes to records
We are being given a range of numbers which need to be used on some of our orders.
We must ensure that each number is allocated only once.
The range of numbers may be more than a million items (not su...
wingyip
Votes: 0
Answers: 0
pyodbc azure sql server error in saving json using openjson
i want to save a json array into azure sql server, but i am getting this error:
\serverCalls\sqlManager.py", line 95, in populateNewsLatest
curse.execute(f"""
pyodbc.Error: ('07002...

utkarsh choudhary
Votes: 0
Answers: 1
Python takes 3ms while Spring takes 80ms to execute the select query from Azure SQL Server?
I have a simple Table created in Azure SQL Database
Below Python script takes only 3ms to to execute the select query from Azure SQL Server
import os
import sys
import logging, logging.handlers
import...

One Developer
Votes: 0
Answers: 1