Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DDL or DML Expand / Collapse
Author
Message
Posted Monday, September 14, 2009 9:25 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 10:44 AM
Points: 2,634, Visits: 3,985
Comments posted to this topic are about the item DDL or DML
Post #787872
Posted Monday, September 14, 2009 9:28 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Simple basic question.

http://en.wikipedia.org/wiki/Data_Manipulation_Language


SQL DBA.
Post #787874
Posted Tuesday, September 15, 2009 6:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, June 7, 2014 9:15 PM
Points: 35, Visits: 60
Of the two answers provided DML is the choice, however:
http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/03/08/why-select-queries-are-not-dml.aspx
there are other opinions.
Post #788086
Posted Tuesday, September 15, 2009 10:15 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 18, 2014 6:41 AM
Points: 907, Visits: 892
It was such a simple question I psyched myself out and assumed it must be a trick. I figured if the answer was DML, the question was too basic to bother asking... so maybe it's considered DDL because it's how you define a return set. I guess they're right: always go with your first answer!

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown
Post #788339
Posted Monday, September 28, 2009 1:15 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 11, 2014 9:24 AM
Points: 994, Visits: 2,232
SanjayAttray (9/14/2009)
Simple basic question.

http://en.wikipedia.org/wiki/Data_Manipulation_Language


And that article says (bolds are mine):

The purely read-only SELECT query statement is classed with the 'SQL-data' statements and so is considered by the standard to be outside of DML. The SELECT ... INTO form is considered to be DML because it manipulates (i.e. modifies) data. In common practice though, this distinction is not made and SELECT is widely considered to be part of DML.


So, which is it?


Post #794712
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse