September 14, 2009 at 9:25 pm
Comments posted to this topic are about the item DDL or DML
September 14, 2009 at 9:28 pm
September 15, 2009 at 6:18 am
Of the two answers provided DML is the choice, however:
there are other opinions.
September 15, 2009 at 10:15 am
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
September 28, 2009 at 1:15 pm
SanjayAttray (9/14/2009)
http://en.wikipedia.org/wiki/Data_Manipulation_Language%5B/quote%5D
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?
:hehe:
--Vadim R.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply