I'm trying to parse the following JSON document : DECLARE @doc nvarchar(max) = ' { "0": { "start_time": "1685959230501", "timestamp": "10:00:30", "running_time": "1.2s", }, "1": { "start_time": "1685959230502", "timestamp": "10:00:30", "running_time": "1.2s", }, "2": { "start_time": "1685959230886", "timestamp": "10:00:30", "running_time":…
currently i`m using very bad query to get the data i whant var map = await mapRepository.SingleAsync(x => x.Slug == slug); var groups = await repository.Queryable() .Include(x => x.Categories.Where(c => c.Locations.Any(l => l.MapId == map.Id))) // if not exist gets…
how to migrate an azure sql database to another subscription in the same tenant Scenario: I have a database server with approximately 600 databases in subscription A , I want to migrate some databases to subscription B in multiple new…
I am getting 0 row when selecting from OPENJSON below. I am expecting to get all 3 values "AA" for different as_of_date for CREDIT_RTG . I tried different select statements. I am running in SQL 2016. Expected result should be…
How to replace text between 2 characters MULTIPLE TIMES in a huge string (50,000 characters) in T-SQL? I have a JSON output from my Azure Pipeline which we drop into a single cell in a table ready for the stored…
Trying to figure out how to convert multiple rows of data to a single row of KeyValue array Setup: using MS SQL SERVER 2017 raw data: Select s.id, s.FkId, s.name ,s.value from tbl s where FkId = 1024180 id |…
I'm finishing my Full Stack Web app (with JWT token authentication based on roles), but im struggling with the front-end. I need to know what is the best practice for obtaining the UserID in the front-end so i can make…
Goal I would like to have a solution, that among other things includes an SQL Server Database Project and a Unit Test Project. (+ integration test project?) That solution is going to be source controlled by a git repository on…
I am having a mssql server running in docker, I want to connect the server using sqlalchemy For connecting, I am using this connection string, engine = create_engine( 'mssql+pyodbc:///?odbc_connect=%s' % ( urllib.parse.quote_plus( 'DRIVER={/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so};SERVER=localhost;' 'DATABASE=ap;UID=sa;PWD=admin@123;port=1433;' )), ) For this, I got…
I'm on ubuntu system trying to connect to my local sql server from my (ASP).net application i configured the string connection "ConnectionStrings": { "DefaultConnection": "Server=localhost\mssqllocaldb;Database=temaintdb;User Id=sa; Password=******;" }, also i enabled the TCP/Ip ,and allowed the port 1433, and tried…