I'm trying to insert and update queries at the same time in stored procedure, but I get a syntax error: #1064 - You have an error in your SQL syntax; check the
I am making a platform where people can make bids on items for a price. I want to make it so that after a the expire datetime of the item, the database will aut
I have an Oracle stored procedure I am trying to execute in SSIS Execute SQL Task. This stored procedure involves refreshing materialized views. For each and ev
Problem background I am trying to pin down to what condition(s) are causing no records / rows the most, so to allow me to find the root cause of what data in th
I am writing a python script that should update a log table and notify me of it. Part of this script is to execute a SQL Server stored procedure. I get an email
I have a table Age_cal, Vaccine Information and Medical_information table as follows: I am trying to write a stored procedure where, I will be able to insert
I am using the following stored procedures (Oracle Database) to export the output of the query to a CSV file CREATE OR REPLACE PROCEDURE run_query(p_sql IN
I need to make an alter table via migration on a node:14 server with umzug. The code is : IF NOT EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_
I am calling a Sybase stored procedure X from another stored procedure Y. Following the answer to a similar question , I create a #tmp_table to hold the results
I have a string: "16680,16678,16677,16676,16675,16672" Which I got from the Stored procedure passed parameter while calling it. I want to insert these records
I am working on a stored procedure that will perform time consuming query (> 30 seconds) inside the engine (arrays, temp tables, ...). The stored procedure r
var get_end_time = "select CURRENT_TIME()"; var time_sql = {sqlText: get_end_time}; var time_create = snowflake.createStatement(time_sql); var time_exec_end = t
I work on sql server 2017 I need to delete all rows from table student_course but I don't know which is best for use delete from student_course OR truncate tab
I'm struggling with a SQL code performance issue, while trying to identify in advance circular references of a dataset with approximately 1.5 MO rows candidates
I am try to create a function that will table input to function and return me output My code : create or replace function details(keyword varchar2 , depid varch
UPDATE: I have tried implementing the SQLData interface for my Financial.class and PersonalInfo.class Java POJOs defined on my @NamedStoredProcedureQuery for th
I am trying use the data from a column in one table as column aliases of another table. DECLARE var1 VARCHAR(20), var2 VARCHAR(20); BEGIN WITH TABLE1
All - thanks in advance for your time. So, background info - I am trying to create a form for contact registration using C# to pass the information into my MyS
I'm trying to send data from excel spreadsheet to sql server. The code runs properly but the change of status is not done. Before those steps, I already added d
I'm trying to create a procedure that add a value that doesn't exist but I'm currently getting a syntax error. I don't know how to correct the error. Any help w