Relational-Databases | Relational Database , PostgreSQL | Object-Relational Mapping library

We are using system-versioned temporal table in our Entity Framework Core application. This works really well but we are experiencing problems when creating a test.

https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver15

I have been following this guide using SQLite in-memory databases to test an EF Core application from Microsoft.

https://docs.microsoft.com/en-us/ef/core/testing/sqlite#using-sqlite-in-memory-databases

The problem is that Sqlite will throw an exception for SysStartTime. This is expected since the property is marked as prop.ValueGenerated = Microsoft.EntityFrameworkCore.Metadata.ValueGenerated.OnAddOrUpdate; in DbContext and is normally handled by Sql Server. Is there anyway to make this work in SQLite?

SqliteException: SQLite Error 19: 'NOT NULL constraint failed: User.SysStartTime'.

User:

I've written a function that requests some data from an API and dumps it in a Storage Account. Then I'm accesing the data in Azure SQL DB using this method. Everything works as intended, but I'm left with the following looking table:

I have Linq statement:

I am trying to implement fault tolerance and trying to collect a list of SQL error numbers that are considered transient. but I keep running into error numbers that have multiple documentations.

Consider error number 10053:

(1) A transport-level error has occurred when receiving results from the server (from here)

(2) Could not convert the data value due to reasons other than sign mismatch or overflow. (from here)

It gets weirder. Consider error number 11001:

(1) Non-NULL value successfully returned.

(2) An error has occurred while establishing a connection to the server....

Both from the same Microsoft docs page adjacent to each other.

What's going on?

I have a JSON object which I have declared in SQL Server like so

When I create a relationship between two tables manually at Database Tools > Relationships, Access lets me set the join properties so that it is either an inner join or a left or right outer join:

But when I create the relationship in VBA:

A project I'm working on involves storing a string of data in a table column. The table will have other columns relevant to the records. We decided to store the string data column using JSON.

From the table, a view will parse the JSON column into separate columns. The view will also have columns derived from the other main table columns. The data from the view is then used to populate parts of a document through SSRS.

When loading data into the main table, I need to utilize separate tables for deriving the other column values and the JSON column. I decided to use common table expressions for this. At the end of the query, I bring together the derived columns from the different common table expressions, including the JSON column, and insert them into the main table.

I had it almost done until I realized that when I use FOR JSON to create the JSON column, it escapes special characters. I did some research and have been trying to use the JSON_QUERY function to get around this but it's not working. Here is a simplification of the problem:

According to MS docs DATEADD is a deterministic function hence my function below should be deterministic too:

I would like to get alerts when certain database errors occur. For instance, if a table or stored procedure is queried against that no longer exists, I want an alert.

I've tried creating alerts for these error codes (208, 2812) but they never trigger, no doubt due to the fact that there are only a handful of error codes that are logged, according to the docs.

From sys.messages:

Is there a way to change the event logged status?