Top "Sql-delete" questions

The SQL DELETE statement allows you to delete a single row or multiple rows from a SQL table.

Counting the number of deleted rows in a SQL Server stored procedure

In SQL Server 2005, is there a way of deleting rows and being told how many were actually deleted? I could …

sql-server tsql audit sql-delete
How do I delete blank rows in Mysql?

I do have a table with more than 100000 data elements, but there are almost 350 blank rows within. How do I …

mysql sql phpmyadmin sql-delete delete-row
TSQL Try / Catch within Transaction or vice versa?

I'm writing a script that will delete records from a number of tables, but before it deletes it must return …

sql-server tsql transactions sql-delete
Java sql delete row

Hello I am trying to delete a row from my database. I am getting no errors but it is doing …

java sql database sql-delete
Best way to delete millions of rows by ID

I need to delete about 2 million rows from my PG database. I have a list of IDs that I need …

sql postgresql bigdata sql-delete postgresql-performance
hibernate and delete all

What is the best way to delete all rows in a table in Hibernate? If I iterate over a collection …

java hibernate sql-delete
Remove all table rows from SQLite database table

I want to remove all rows that i entered from my SQLite database table. The table name is tbltask. I …

android sqlite sql-delete
Delete from one table with join

I'm trying to delete records from one database based on a selection criteria of another. We have two tables, emailNotification …

mysql left-join sql-delete
How to delete data from multiple tables?

I have these tables: event (evt_id, evt_code, reg_id) magnitude (mag_id, evt_id, value) trace (trace_id, …

sql postgresql foreign-keys sql-delete
How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table

Let's say we have table Sales with 30 columns and 500,000 rows. I would like to delete 400,000 in the table (those where "…

sql sql-server-2008 tsql sql-delete truncate