3 ms·

What is "DMLname" in "tablename_DMLname_[description]" ?

• sime 13y ago
  DML is short for data manipulation language as opposed to DDL which is data definition language. So in this case it's including in the stored proc name the type of data manipulation operation being performed by the proc. In the example "sel" is short for select so it's a query operation. You would also have insert, update and delete.
• 9876543210 13y ago
  A named query, or any other form of named SQL statement. It could be a view (a select query, stored as a database object) or a procedure (a grouped set of sql statements that might involve changes that are written to the database, possibly a simple insert, or simple update, or simple delete, but potentially much more complex). DML is one class of SQL statements, and DDL is another. The two together encompass most of your common, practical database operations.
• jmnicolas 13y ago
  Got it, thank you both.