Mysql – Query outer join fixed values
I would like to query some IDs (fixed values) into a table, like a "outer join" with the mandatory fields should be the fixed values. I have to do the same for SQLServer and MySQL, but with one solution I…
Use SQL query to extract data from an external SQL Server database in Azure databricks
I am connecting to an on prem SQL Server database using the code below and it works as expected. I have wrapped the query I want to use in a view and I called the view to read the data…
Ubuntu – Read csv and get table data and write as text file output
I have a csv file which has the below mentioned data of Table names in a sql server instance in ubuntu. Tables TableName1 TableName2 TableName3 . . . I want to read this csv file and I want to get…
Visual Studio Code – After updating Visual Studio 2022 Enterprise to version 17.10.1, I get the error "Frame not in module" when debugging SQL. How can I fix this?
I have recently updated my Visual Studio 2022 Enterprise to version 17.10.1. When debugging SQL from within VS, I encounter the error Frame not in module (the current stack frame was not found in a loaded module. Source cannot be…
Visual Studio Code – Debug SQL query in Visual Studio 2022
I am trying to debug Microsoft SQL Server stored procedure from Visual Studio 2022. When I step into the code, I see what is shown in the screenshot. The actual stored procedure is not getting opened. Is there any solution…
Troubleshooting connection issue: ASP.NET Core 8 MVC project containerization with SQL Server Docker container
I have an ASP.NET Core 8 MVC project that I've containerized. Initially, I pulled a SQL Server image from Docker Hub and then modified the default connection as follows: "ConnectionStrings": { "DefaultConnection": "Server=mysql-container,3306;Database=ProductsDB;User Id=root;Password=my-secret-pw;" }, However, upon attempting to access…
Azure – Grafana + Synapse Serverless via Microsoft SQL Server: External table is not accessible because content of directory cannot be listed
I have set up an Azure Synapse Serverless SQL Pool, with the goal of reading data from a Parquet data lake stored in an Azure Data Lake Gen2 container. Within Synapse Studio, I can create an SQL script as below,…
How to use the text that search with FTS by parameter in ASP.NET C#
I coded a site with ASP.NET, C# and a SQL Server database. I want to search in database with full-text search by passing a query from C# to SQL Server. In summery, the problem occurs when I use parameters, but…
Powershell or AzureCLI command to enable Microsoft Defender for SQL
Because I am not allowed to enable Microsoft Defender for SQL from Azure Portal, I am tring to find a Powershell or AzureCLI command to enable it from CloudShell. The final step is to use that command in a pipeline.…
Mysql – Why this SQL query with EXISTS is not working?
I wrote this query to show me the last purchase of each customers using "EXISTS" but it is not working. it returns all of the rows without filtering them. Can you please advise me how to resolve this issue? Thank…