Long-standing classes for SQL statements originated back in the days of the SQL92 standard. These classifications are still common: Data Manipulation Language (DML): SQL statements which manipulate data, such as SELECT, INSERT, UPDATE, DELETE and MERGE. Data Definition Language (DDL): SQL statements control the creation, modification, and removal of database objects, such as CREATE, ALTER and DROP. Data Control Language (DCL): SQL statements related to permissions to execute and access database objects and data, such as GRANT and REVOKE. Starting with SQL3, seven core categories define the … [Read more...]
SQL Statement Classes
Filed Under: Explanation Tagged With: ANSI SQL, RDBMS, Relational Database Theory
Join O’Reilly on Facebook
O'Reilly Media on Facebook is a place for for anyone who is a fan of O'Reilly, whether you've been following their books, conferences, webcasts, and more since the very beginning or you recently jumped onto the bandwagon. I really enjoy the newsletters and blogs from O'Reilly's various channels, especially Tim O'Reilly's commentary. And, of course, there's my book - SQL in a Nutshell - published by O'Reilly for your consideration. This book provides a complete reference of the latest release of the ANSI SQL standard, as well as full coverage of support for the ANSI standard from the … [Read more...]
Filed Under: On-Line Resources, SQLServerPedia Syndication Tagged With: ANSI SQL, DBA, Developer, MySQL, Oracle, PostgreSQL, SQL Server 2008, Transact-SQL Programming
