T-SQL Coding - What is the difference between SQL Server DDL and DML commands? Can you name some examples of each?

Question

Post reply

T-SQL Coding - What is the difference between SQL Server DDL and DML commands? Can you name some examples of each?

Arjun SreeVastsva

SSCertifiable

Points: 7141
More actions
February 17, 2010 at 5:55 am

#216831

T-SQL Coding - What is the difference between SQL Server DDL and DML commands? Can you name some examples of each?

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150467 More actions · Answer 1

Removed.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

george sibbald SSC Guru Points: 104210 More actions · Answer 2

I think we are being tested.

---------------------------------------------------------------------

Tim Januario-145496 Ten Centuries Points: 1391 More actions · Answer 3

The difference between DDL and DML results in a Operand data type varchar is invalid for subtract operator exception. Was that a trick question?? (several days later I am editing my response because I agree with later posts about professionalism and people's use of this site for research (but not removing because, well... because). Here is my excuse for my tongue-in-cheek answer: I noticed the trend in questions by the same user and made an assumption that either the person was just trying to build up their points (is this edit worth another point in addition to my original post BTW :Whistling: ), or just misusing the forums, the interview thing seems even more logical)

Tim Januario

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Tim Januario-145496 (2/17/2010)
The difference between DDL and DML results in a Operand data type varchar is invalid for subtract operator exception.

RotFL. Lovely. 😀

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

matzer SSCrazy Eights Points: 9727 More actions · Answer 5

Tim Januario-145496 (2/17/2010)
The difference between DDL and DML results in a Operand data type varchar is invalid for subtract operator exception. Was that a trick question??

Strange.

select difference('DML', 'DDL')

gives me 3.:-)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

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

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

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 7

GilaMonster (2/17/2010)
http://en.wikipedia.org/wiki/Data_Definition_Language
http://en.wikipedia.org/wiki/Data_Manipulation_Language

Can I forward the links in the interview ?

There are a dozen Interview Questions from this user in the last 30 mins.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

Wow you guys look like a***** right now...

I'm glad to not be a part of this anymore!

It seems like a legit question to me. If you think this is an interview question then just come back 24 hours later and give the answer, no need to laugh at him / her.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

nevermind... I saw his other "questions" from this morning...

if you can waste time posting why not use google!!!

Lowell SSC Guru Points: 323518 More actions · Answer 10

Remi you've got to look at the recent posts; he's pasted about a dozen interview questions to the forums, instead of googling. Even changed his screen name once since this morning.

I admit it's a bit of a pile on now, but he didn't even bother to google a single question.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

george sibbald SSC Guru Points: 104210 More actions · Answer 11

Ninja's_RGR'us (2/17/2010)
I'm glad to not be a part of this anymore!
It seems like a legit question to me. If you think this is an interview question then just come back 24 hours later and give the answer, no need to laugh at him / her.

go to active threads, you will see 10 or more of these type of questions all posted at the same time. Its either an interview question or poor use of a forum environment.

---------------------------------------------------------------------

george sibbald SSC Guru Points: 104210 More actions · Answer 12

Ninja's_RGR'us (2/17/2010)
nevermind... I saw his other "questions" from this morning...
if you can waste time posting why not use google!!!

our posts crossed. Exactly our point.

perhaps edit your previous post please?

---------------------------------------------------------------------

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 13

george sibbald (2/17/2010)
Ninja's_RGR'us (2/17/2010)
nevermind... I saw his other "questions" from this morning...
if you can waste time posting why not use google!!!
our posts crossed. Exactly our point.
perhaps edit your previous post please?

I agree, I think it appropriate if you removed the a word from your earlier post.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

Ninja's_RGR'us

SSC Guru

Points: 294069

February 17, 2010 at 7:32 am

#1120078

... done.