Forum Replies Created

Viewing 15 posts - 106 through 120 (of 257 total)

  • RE: SQL JOINS

    Good start of week.

    Thanks for question.

    🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 14, 2013 at 11:47 pm

    #1606351

  • RE: DateTime data types

    Thanks for start my day with an easy question.

    Still i found result as "Correct answers: 100%"

    Nice question, keep it up my friend !!!

    🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 10, 2013 at 11:14 pm

    #1605467

  • RE: Identity Columns

    Easy question. keep it up 🙂

    +1

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 9, 2013 at 11:17 pm

    #1605093

  • RE: TRIGGERS

    kapil_kk (4/9/2013)

    Good question Vinay ans as usual gr8 explanation from Hugo 🙂

    🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 9, 2013 at 6:29 am

    #1604779

  • RE: TRIGGERS

    Hugo Kornelis (4/9/2013)

    Danny Ocean (4/9/2013)

    BUT statement 6 (ID 4 & 5) execute successfully and inserted two rows in table. In this we are using UNION ALL.

    How it's possible ? Anyone...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 9, 2013 at 4:40 am

    #1604752

  • RE: TRIGGERS

    Friends, i have a question. I have made same changes in script and execute it. First have a look on script

    --statement 1

    CREATE TABLE temp

    (

    ID INT NOT NULL,

    MyText varchar(max) NOT...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 9, 2013 at 3:50 am

    #1604734

  • RE: TRIGGERS

    Hugo Kornelis (4/9/2013)

    I'm glad I double and triple checked before replying; I almost fell for it. The glaring error in how the trigger code handles multi-row inserts is so staring...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 9, 2013 at 12:53 am

    #1604684

  • RE: TRIGGERS

    kapil_kk (4/8/2013)

    Danny Ocean (4/8/2013)

    I don't see the table definition carefully and choose incorrect option.:angry:

    Any way Good question, keep it up; 🙂

    Same here Vinay, forget about the TEXT datatype part and...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 8, 2013 at 11:44 pm

    #1604667

  • RE: TRIGGERS

    I don't see the table definition carefully and choose incorrect option.:angry:

    Any way Good question, keep it up; 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 8, 2013 at 11:14 pm

    #1604663

  • RE: ISNUMERIC

    +1 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 7, 2013 at 11:25 pm

    #1604282

  • RE: Resource Governor

    I just guess and got correct 2 out of 3.

    :doze:

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 4, 2013 at 11:39 pm

    #1603806

  • RE: LEFT JOIN

    Thanks Hugo for last two lines.

    🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 4, 2013 at 1:52 am

    #1603453

  • RE: LEFT JOIN

    kapil_kk (4/4/2013)

    Hi all,

    I also thinks that the options are not well written... Sorry for that 🙁 ..

    My point of concern was to to throw light on different behaviors of AND...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 4, 2013 at 12:26 am

    #1603439

  • RE: LEFT JOIN

    baabhu (4/3/2013)

    For me at least option b and option d looks pretty much similar.

    option B.

    Query 1 will return all rows of table 1 and Query 2 will return...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 3, 2013 at 11:47 pm

    #1603435

  • RE: Assigning values to Variables with CASE

    Good example. But rather than creating six different variables, i would like to create only one variable and use sp_executesql.

    Anyway. Thanks for question.

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    April 2, 2013 at 11:22 pm

    #1603027

Viewing 15 posts - 106 through 120 (of 257 total)