Stack Overflow
Stack Overflow

Questions tagged [dml]

Data Manipulation Language(DML) is database syntax used for SQL commands, including the INSERT, UPDATE, and DELETE statements. DML triggers operate on INSERT, UPDATE, and DELETE statements, and help to enforce business rules and extend data integrity when data is modified in tables or views.

A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML.

A popular data manipulation language is that of Structured Query Language (SQL), which is used to retrieve and manipulate data in a relational database. Other forms of DML are those used by IMS/DLI, CODASYL databases, such as IDMS and others.

References:

DML related tags

539 questions
0
votes
2 answers

SQL server - inserting a string with a single quotation mark

I iterate over an external source and get a list of strings. I then insert them into the DB using: SqlCommand command = new SqlCommand(commandString, connection); command.ExecuteNonQuery(); Where commandString is an insert into command. i.e. …
Bick
  • 17,833
  • 52
  • 146
  • 251
0
votes
1 answer

How to remove redundant data from the DML

MDW_BILL1 has the following columns BILL_ID NOT NULL VARCHAR2(10) CUSTOMER_ID VARCHAR2(10) MONTH VARCHAR2(10) YEAR NUMBER TOTAL NUMBER ACTIVE_INDICATOR VARCHAR2(10) MDW_BILL_TRANSACTION1 has the following columns: BILL_TRANSACTION_ID NOT NULL…
debal
  • 997
  • 4
  • 15
  • 29
0
votes
1 answer

Update related table (Postgres)

I am Creating two table in Postgres. 1st table have one primary column and other columns & in 2nd table have one primary column "MLeaseId" those column same in 1st table (not primary of 1st table) and others column. How I copy data from 1st table…
sanjay singh rajput
  • 1
0
votes
0 answers

alter table waiting for select query to get executed

I have a use case where i dynamically add new columns to db.The alter table works fine when no select queries are running on the db table.But if alter query is running at the same time when some heavy (i mean time consuming ) select query is running…
user93796
  • 18,749
  • 31
  • 94
  • 150
0
votes
1 answer

How to look at past DML on your table?

a friend asked me if there is a way to see the past dml statements and I wasn't really sure on how to go about answering that question. What he wants to see is the last set of insert statements. So that means it could be more than 1 record. At…
crack3r
  • 49
  • 1
  • 5
0
votes
2 answers

creating a trigger for the default phone format using T-SQL

I have created a trigger that ensures that the phone number is inserted in the default format into the database. It was created for the Oracle database. Now I'm working in SQL Server 2008 R2 and have troubles converting this trigger. Can anybody,…
user2155410
  • 1
  • 1
  • 1
0
votes
5 answers

Terminology: DML "that modifies things"

I understand that DML technically encompasses SQL verbs which merely query but do not modify persistent data. (See, e.g., wikipedia or oracle or orafaq) However, I often wish to refer to "all and only those SQL verbs which modify stored/persistent…
pilcrow
  • 56,591
  • 13
  • 94
  • 135
0
votes
1 answer

DML query execution from datagridview to SSCE

What I am trying to do: Execute DML statements into database (SSCE) using Datagridview and command buttons. The Problem: I am getting exact same error as this post: SQL [Error]: There was an error parsing the query. [ Token line number = 1,Token…
aspiring
  • 1,557
  • 2
  • 20
  • 43
0
votes
1 answer

Put and Delete with CouchDB + Lucene

I'm running CouchDB (1.2.1) + Lucene on Linux (https://github.com/rnewson/couchdb-lucene/), and I have a few questions. I index everything - one index for all documents. i've got around 20.000.000 documents. How fast are puts/deletes done on the…
user2001384
  • 1
0
votes
1 answer

Write heavy dml-operations in MongoDB

I'm running MongoDB (2.2) on Linux, and I have a few questions. I have schema with many fields + sub-fields and one index for this fields. How fast are updates/delete done on the index -- I have about 3 Updates/Deletes etc. a second. Is there a…
user2001384
  • 1
0
votes
3 answers

Update Statement with two tables -Oracle

I have two tables and I need to Update the second table with a value from first table based on a common column. I used the below statement UPDATE emp 2 SET ename = ( SELECT dname 3 FROM dept 4 WHERE…
user1969171
  • 17
  • 1
  • 2
0
votes
2 answers

sql server 2005 ----- how to update multiple rows using subquery

I have 2 tables named as member and tree_str... "member" table as follows self_id parent_id position 100 ROOT ROOT 101 100 LEFT 102 100 CENTRE 103 100 RIGHT 104 101 LEFT …
manish
  • 27
  • 3
0
votes
0 answers

Query and Subquery SQL DML

I have tried to this query:What are the names of the hospitals where work all the doctors that work on it's country. But the result isn't what I expected and it has a syntax error. I have these tables: CREATE TABLE Hospital ( hid INT PRIMARY…
tomss
  • 269
  • 4
  • 6
  • 12
0
votes
1 answer

SQL DML Oracle query

I have tried to do this query: What are the name of hospitals in Spain where work more than 2 doctors that only work for that hospital. But the result isn't what I expected. I have these tables: CREATE TABLE Hospital ( hid INT PRIMARY KEY, …
tomss
  • 269
  • 4
  • 6
  • 12
0
votes
2 answers

SQL DML query - need assistance

I am beginner at SQL and I am trying to create a query. I have these tables: CREATE TABLE Hospital ( hid INT PRIMARY KEY, name VARCHAR(127) UNIQUE, country VARCHAR(127), area INT ); CREATE TABLE Doctor ( ic INT PRIMARY KEY, …
tomss
  • 269
  • 4
  • 6
  • 12
1 2 3
…
35 36