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…
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…
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…
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…
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…
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,…
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…
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.…
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…
While waiting for approval to downgrade my client's PHP version to 8.2, I'm wondering if anyone here has found a workaround to enable SQL Server support on PHP 8.3. So far I have managed to connect using php_odbc, but it…