python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sql-delete

Declare and return value for DELETE and INSERT

I am trying to remove duplicated data from some of our databases based upon unique id's. All deleted data should be stored in a separate table for auditing purposes. Since it concerns quite some datab...
test-img

Bobstar

postgresql

sql-insert

plpgsql

sql-delete

dynamic-sql

Votes: 0

Answers: 3

Latest Answer

You need to create and then call a plpgsql procedure with input parameters : CREATE OR REPLACE PROCEDURE duplicates_suppress (my_target_schema text, my_source_schema text, my_source_table text, unique...
test-img

Edouard

How iteration names of tables and delete records from them?

I am trying to create a procedure in which I create a variable -> @table_name and assign a select, that gets a list of tables names from sys.table. Then I need to insert the @table_name to line wit...
test-img

Alex

sql-server

iteration

sql-delete

Votes: 0

Answers: 1

Latest Answer

I believe you need to use a cursor to loop through the selected table names and then construct and execute dynamic SQL. Something like: declare @name sysname declare @sql nvarchar(1000) declare tabl...
test-img

T N

Swift http delete request with php not working

I had tried many times in Swift, seem the problem happened in the PHP file. i dont know the data tpye of $revaID correct i get $revaID value from swift, i want to use revaID to delete row from table r...
test-img

zdrg

php

swift

phpmyadmin

httprequest

sql-delete

Votes: 0

Answers: 1

Latest Answer

in a swift file, you are sending data with get method and in a PHP file you are trying to get data with post method. so instead of this : $revaID = $_POST["revaID"]; ; try to get data by ...
test-img

Shabnam Siddiqui

PostgreSQL, delete values from a table that match the output of a query on the table the values are being deleted from

I'm capturing data from a database each day, by running an insert statement using a query and the values for whatever the current date is when the query is run. To stop the table from getting too larg...
test-img

Scott Renfree-Tuck

postgresql

sql-delete

Votes: 0

Answers: 1

Latest Answer

and sct."Date" = t1."First Date of Status" and t1."First Date of Status" is null This will never work. You need to understand three-valued logic. null = nu...
test-img

Richard Wheeldon

Posts

Questions

Blogs

Jobs