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

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

  • Removed.

  • I think we are being tested.

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

  • 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

  • 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
  • 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.:-)

  • 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
  • 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

  • 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.

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

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

  • 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!

  • 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.

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

  • 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?

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

  • 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.

  • ... done.

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

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