Top "Dml" questions

How to truncate a foreign key constrained table?

Why doesn't a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (42000): Cannot truncate …

mysql foreign-keys constraints truncate dml

What are DDL and DML?

I have heard the terms DDL and DML in reference to databases, but I don't understand what they are. What …

sql ddl dml

SQL Server TOP(1) with distinct

I am trying to extract the first row I get after ordering the result by i_version_id. If I …

sql sql-server database dml

Selecting all columns and constant value from Oracle table

How can I select all columns and add a column with a constant value in Oracle? With MS SQL Server, …

sql oracle select dml

Combine stored procedure and query in T-SQL

How do I combine executing of a stored procedure and using its result or parameters in a regular SQL query? …

sql sql-server tsql stored-procedures dml

How to copy an inserted,updated,deleted row in a SQL Server trigger(s)

If a user changes table HelloWorlds, then I want 'action they did', time they did it, and a copy of …

sql-server tsql triggers dml

hibernate update single column using criteria

I have a table that contains mamy columns and I want to update the one or few columns of the …

hibernate hibernate-criteria dml

SQL DML: Incorrect date value (MySQL)

I created a table in my database: CREATE TABLE official_receipt( student_no INT UNSIGNED, academic_year CHAR(8), trimester ENUM(…

mysql insert-into date-format dml

Oracle: why parallel delete doesn't go parallel?

I've tried the following statement. But it doesn't proceed parallel. Why? How can I speed up the operation? ALTER SESSION …

sql oracle parallel-processing dml

SQL Server Trigger switching Insert,Delete,Update

Hello is possible to switch between DML commands/operations (Insert,Delete,Update) on Trigger Body?, I try to snippet some …

sql-server triggers dml