Creating a logic app to retrieve data from SQL server in JSON format. Calling SQL Stored Proc from Logic App trigged via HTTP Request. And using below select Query - FOR JSON to create the output as JSON and using…
I have a sample console application running on .NET 4.8 Framework. Application is able to connect local SQL Server. But when I run the application inside the docker container, I am not able to establish connection between the application and…
I have a table in my database that tracks visitors page views and I am trying to pull out the utm tracking parameters from the url https://www.example.com/?utm_source=Adwords&utm_medium=ppc&utm_campaign=PGLawBrand&utm_ID=18075&mh_matchtype=e&mh_keyword=university%20of%20law utm_medium = ppc utm_source = Adwords utm_campaign = PGLawBrand utm_id = 18075 You…
I am wondering if there is a function in SQL Server or service in Azure to provide an opportunity to combine multiple queries into one. For example, ALTER TABLE1 ADD RetailValue AS (CAST(QtyAvailable AS int) * CAST(UnitPrice AS int) *…
Is there someone who can help me figure out why I cannot query an external table that I created using my SQL Server Mgt Studio. I can see the external table if I expand External Tables but if I Right…
In my Azure environment I have private SQL Server. To access SQL Server and databases I use a private endpoint. When I connect to SQL from VM in the same Virtual Network I have no problem. I have AKS in…
I am trying to run a SQL Server container on my mac through Docker. I ran the following command: docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=strongpassword" -p 1433:1433 --name sqlservercontainer -d mcr.microsoft.com/mssql/server:2019-latest But the container is immediately exiting. The docker logs…
I have been trying to download SQL Server on my Mac with an Apple Chip. I've been following the steps that include downloading docker and entering code into my terminal to set up the images and containers within docker. However,…
In my code first, I insert a record for a SQL table. then I want to update the same table after checking an API response. For that, I want to get the inserted record id and pass it to the…
I create a new image base on the "mcr.microsoft.com/mssql/server" image. Then I have a script to create a new database with some tables with seeded data within the Dockerfile. FROM mcr.microsoft.com/mssql/server USER root # CreateDb COPY ./CreateDatabaseSchema.sql ./opt/scripts/ ENV ACCEPT_EULA=true…