How do I connect to SQL server with PHP?
I work with xampp PHP 8.1 I'm trying to connect to SQL Server. I downloaded the drivers, but when starting xampp I get the message (in the log file) that the drivers are not found. I have no idea what…
How do you unpivot GA4 (Google Analytics 4) event_params (JSON) in SQL Server?
We are exporting GA4 (Google Analytics 4) data from Big Query via a built-in Microsoft connector. Everything is coming through, but the event_params is in a very unusual JSON format. I have unpivoted numerous other arrays from different sources with…
How can I convert this Json array in SQL Server?
I have an array like this and I want to extract its count into a single array. Can I do this in SQL Server? [ { "ItemName": "ITEM1", "Details": [ { "column1": "2021/Apr", "Count": 10 }, { "column1": "2021/May", "count":…
SQL Server : parsing a JSON column with irregular values
I have SQL Server 2016 (v13) installation where I am trying to parse a column with JSON data. The data in the column RequestData is in the following format: [ { "Name": "SourceSystem", "Value": "SSValue" }, { "Name": "SourceSystemId", "Value":…
Azure – SSDT – specify authorization user on schema create
I have a sqlproj XML for Azure SQL Database. I want to deploy database with several tables into specific schema which is also created using this build. How to specify what user should be used for CREATE SCHEMA [schema-name] AUTHORIZATION…
Error code 0x2746 (10054) when trying to connect to SQL Server 2014 via ODBC from Linux – Ubuntu
Ubuntu 22.04.1 LTS pyodbc 4.0.35 OpenSSL 3.0.2 15 Mar 2022 (Library: OpenSSL 3.0.2 15 Mar 2022) Followed steps on Install the Microsoft ODBC driver for SQL Server (Linux) Installation successful. When I run this snippet def select_driver(): """Find least version…
how to delete properties in array using JSON_MODIFY in sql server
I have a complex json stored in a varchar(max) column. I have an array of strings in the json. myArray: ['one', 'two', 'three', 'four'] I am running the following update query to delete property two from the array above using…
SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user – PHP Versions
I'm using the following PHP connection file to connect to my SQL Server database. <?php $servername = "..."; $username = "..."; $password = ""; $dbname = "..."; try { $conn = new PDO("sqlsrv:Server=$servername;Database=$dbname", $username, $password); echo "Connected to $dbname at…
Get Array Index from JSON data SQL Server
{ "Name": ["dokumen_1","dokumen_2","dokumen_3","dokumen_4"], "Date": [0,0,0,0], "Progress": [0,0,0,0] } I want to fetch Date and Progress value according to Name position.
Sql Server: Select String array of JSON
Given the following test data: declare @mg nvarchar(max); set @mg = '{"fiskepind":["ko","hest","gris"]}'; select @mg, JSON_VALUE(@mg,'$.fiskepind') How do i get returned a column with: ko,hest,gris Example returns: NULL, and i dont want to [index] to only get one returned.