#stored-procedures

[ follow ]
#mysql

Checking that today's date is the first Monday of the current year

On the first Monday of the year, the date range used in the query may lead to no results due to the start date being after the end date.

Problem in a stored procedure if you try to pass variables using MySQL

You need to ensure that the variable 'period' is accessible in the dynamic SQL context.

Checking that today's date is the first Monday of the current year

On the first Monday of the year, the date range used in the query may lead to no results due to the start date being after the end date.

Problem in a stored procedure if you try to pass variables using MySQL

You need to ensure that the variable 'period' is accessible in the dynamic SQL context.
moremysql

EF8 - Row SQL returning Non-entities

EF8 allows including any row SQL query returning mappable C#/.NET types without them being in the EF model.
Executing arbitrary SQL statements or Stored Procedures in EF8 is simpler and can be further manipulated with LINQ.

CockroachDB tempts legacy databases to crawl to the cloud

CockroachDB has released version 23.2 with new features aimed at attracting mainframe and legacy database users.
The update includes improved support for stored procedures, making them more powerful and suitable for enterprise workloads.
CockroachDB aims to provide better compatibility with PostgreSQL and is wire-compatible; it also uses a distributed execution engine for processing large amounts of data in parallel.
[ Load more ]