I am facing issue with inserting the JSON array into tables Doc Table : Id, Name, Desc, RefName, IsActive Con Table : Id, Field, Criter, DId, Conjunction, IsActive We map doc table Id Column to DId column This is sample…
I have a stored procedure returning a table. Is it possible to have the same output in a view instead of a stored procedure? Is there any way to return the function in a view? CREATE PROCEDURE `getReservedDevices`(IN `location_id` INT(11),…
I currently have a stored procedure that accepts TEXT as input, and then tries to find the matching ids within the set. The input_ids value is an array of longs '1,2,3,...'. It works but the problem is that find_in_set is…
In my ASP.NET web application I want to show to the end user the progress of the stored procedure. The stored procedure computes a batch of calculations depending on how many the user added to the task basket. It works…
My task is to insert data into an existing table. My table is called user_entity. Columns: id (PK) 36 example - "a0a16d3f-ad38-491d-a98d-5af80428e139" email email_constraint email_verified enabled (true/false) first_name last_name realm_id username created_timestamp not_before I want to write a loop to…
I am migrating from Advantage Database Server 11 to MySQL 8.0.33 and also testing MariaDB 11.0.2. I haven't landed on which one to use yet but I know I will need to use cursor variables and cursors within cursors a…
Hi I'am trying to return a the value of output parameter of oracle stored procedure using PDO. I have a class called Sql and in the constructor I am doing the connection to the database then I am using those…
With this schema: CREATE TABLE tag ( tag_id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, tag_slug text UNIQUE NOT NULL, tag_name text NOT NULL ); I'm currently using Javascript to generate a bulk UPSERT command, like this (it uses…
I am currently migrating a PostgreSQL procedure to work in Redshift Spectrum Serverless. I was able to have a working procedure that works as intended in Redshift. However, its originally used inside a SQL select statement and I am currently…
I need to get the upcoming saturday based on the date field in table. I need to implement code using snowflake javascript stored procedure. Suggestions appreciated. When following query is executed using snowflake console, I get result. SELECT next_day(TO_DATE(MAX(SALE_DATE)),'Saturday') FROM…