Post reply

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

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

  • February 17, 2010 at 5:59 am

    #1119990

    Removed.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • February 17, 2010 at 6:10 am

    #1119999

    I think we are being tested.

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

  • February 17, 2010 at 6:12 am

    #1120000

    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

  • February 17, 2010 at 6:21 am

    #1120010

    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

  • February 17, 2010 at 6:35 am

    #1120028

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

  • February 17, 2010 at 6:38 am

    #1120032

    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

  • February 17, 2010 at 6:42 am

    #1120036

    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

  • February 17, 2010 at 6:54 am

    #1120048

    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.

  • February 17, 2010 at 6:56 am

    #1120049

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

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

  • February 17, 2010 at 6:58 am

    #1120052

    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!

  • February 17, 2010 at 6:59 am

    #1120053

    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.

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

  • February 17, 2010 at 7:00 am

    #1120055

    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?

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

  • February 17, 2010 at 7:19 am

    #1120064

    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.

  • February 17, 2010 at 7:32 am

    #1120078

    ... done.

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

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