Does anyone know how I can make a generated column in Postgres? This is the code in SQL Server: CREATE TABLE [dbo].[PRICE] ( [ISIN] [varchar](50) NOT NULL, [Nemo] [varchar](50) NOT NULL, [Month(t)] [int] NOT NULL, [Month(t-1)] [int] NOT NULL, [Month(t-2)]…
I have a JSON file that contains transactions, and each transaction contains multiple items. I need to flatten the data into SQL Server tables using T-SQL. I have tried different options to flatten it, but it looks like I am…
I'm currently trying to answer a problem that can only be answered by combining the datasets of two different Azure SQL databases (different servers, if that matters). When using user+password authentication, there was a way to do cross-database queries like…
ASP.NET Core 3.1 app deployed on IIS not connecting to local db but its connecting to something. The app is working Application 'C:inetpubwwwrootretailbanking' started successfully. on windows logs. I have a bunch of users registered in dbo.aspnetusers but when I…
I have an API which I've upgraded from .NET Core 3.1 to .NET 7. It's now throwing an error when trying to connect to the database. The error is: A connection was successfully established with the server, but then an…
I'm trying to find out, why a simple aggregate query performs really slow on Postgres 15 from my point of view. I have a growing data table with 10 mio records of sensor data CREATE TABLE public.ts_number ( id int4…
Let's say We have class parent public class Parent { int Id {get;set;} Child child {get;set;} } And class child public class Child { int Id {get;set;} string Info {get;set;} } I create an object of child and save it…
I am trying to map my Name column to a dynamic object. This is how the raw JSON data looks (note that this is SQL-morphed from our old relational data and I am not able to generate or interact with…
I have retrieved data from a MSSQL server table. I was able to display them thanks to a query. I would like to be able to modify these data without touching the table For example the values which are in…
I've checked stackoverflow as well as google but could not find any solution. What would be the proper way to remove duplicate entries from an nvarchar field that contains json string in SQL Server? For my case, let say I…