I have installed a .Net Framework 4.5.2 Web app into Azure, which is set up to use Entra authentication. The app needs to connect to a SQL Server database in the Azure account. The Azure UI shows a variety of…
I'm trying to connect to a SQL Server Docker container via SQL Server Management Studio, but it doesn't work. When I attempt to connect, I get this error: Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456) I run…
I am trying to crease a managed SQL instance in Azure and keep running into issues with the timezone. I am trying to use the EST timezone. I have tried EST and America/Indianapolis and I am still unable to resolve…
SQL query to check if a key exists and its value is null in JSON column Extending this question, if I want to query for multiple keys, it works fine for me with both AND and OR in a SQL…
I have a SQL Server database table with this structure: CREATE TABLE json_file_table ( file_id VARCHAR(50) PRIMARY KEY, json_value VARBINARY(MAX) ); How to write a SQL query to insert value into the database and bind values to that query in…
I have my JSON objects in this format: [ { "id": "k002f3d", "usage": { "sent": 0, "recv": 2, "total": 2 } }, { "id": "k641327", "usage": { "sent": 0, "recv": 2, "total": 2 } }, { "id": "k6419b2", "usage": {…
I need to calculate the (quarterly sessions conversion rate) = (number of orders) / (number of sessions) for an online store. Here is the data table: CREATE TABLE orders_full ( order_id, sessions_id, created_time ) CREATE TABLE sessions_data ( -- records…
While Converting the DataTable to Json File, the field with DateTime is converting to a */Date(1722796200000)/*? there is any solution to convert the method to a real datetime or json datetime format "2024-08-05T00:00:00" Structure of DataTable DataTable dt = new…
I am trying to containerise a .NET framework 2.0 legacy application connecting to SQL Server on localhost outside the Docker, I am able to containerise the application but it doesn't connect to SQL Server. Even I comment out the connection…
I have the following tables (many-to-many): DROP TABLE IF EXISTS [dbo].[ItemOwner], [dbo].[Items], [dbo].[Owners] GO CREATE TABLE [dbo].[Items] ( [Id] [int] IDENTITY(1,1) PRIMARY KEY CLUSTERED, [Name] [varchar](max) NOT NULL ); CREATE TABLE [dbo].[Owners] ( [Id] [int] IDENTITY(1,1) PRIMARY KEY CLUSTERED, [Name]…