Forum Replies Created

Viewing 15 posts - 571 through 585 (of 1,048 total)

  • RE: storing output of a Stored Procedure in a vairable

    yess I can do it 🙂

    April 23, 2013 at 7:41 am

    #1609057

  • RE: Nested triggers 1

    Hugo Kornelis (4/23/2013)

    The first sentence of the explanation should probably have read "Instead of triggers can cascade regardless of the setting of the nested trigger server option."

    The question IDEA is...

    April 23, 2013 at 6:49 am

    #1609026

  • RE: Nested triggers 1

    gr8888 question Tom 🙂

    Thanks a lot!!

    April 23, 2013 at 12:03 am

    #1608942

  • RE: Handling NULL

    One minor mistake i found that, You need output like "Apr 9 2013 11:38AM", But below all queries give today day. oops !!! 🙂

    Hi Vinay,

    Actually, I run this scenario...

    April 21, 2013 at 11:42 pm

    #1608587

  • RE: Master Database

    Kenneth.Fisher (4/19/2013)

    You can use the object property isMSShipped to help you find user created objects.

    SELECT *

    FROM sys.objects

    WHERE objectproperty(object_id, 'ismsshipped')=0

    good one Kenneth..

    I was not aware of property 'ismsshipped'

    April 20, 2013 at 1:05 am

    #1608455

  • RE: Updation using fuction

    Thanks Lynn and Sean I will implement in this manner and let you guys know after implementing in that way 🙂

    April 19, 2013 at 10:10 pm

    #1608448

  • RE: Updation using fuction

    kapil_kk (4/19/2013)

    Sean Lange (4/19/2013)

    kapil_kk (4/19/2013)

    Sean Lange (4/19/2013)

    You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you...

    April 19, 2013 at 8:51 am

    #1608271

  • RE: Updation using fuction

    Sean Lange (4/19/2013)

    kapil_kk (4/19/2013)

    Sean Lange (4/19/2013)

    You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you could...

    April 19, 2013 at 8:27 am

    #1608253

  • RE: Updation using fuction

    Sean Lange (4/19/2013)

    You can't do updates/insert/deletes in a function. You would need to make this a stored proc instead. Have you considered MERGE? I think you could probably turn this...

    April 19, 2013 at 7:52 am

    #1608228

  • RE: Triggers 1

    IgorMi (4/19/2013)

    kapil_kk (4/18/2013)

    oopes,

    I think I have misunderstood the way to execute the given query...

    After seeing comments First Attempts, second, third I executed one by one those insert query and forget...

    April 19, 2013 at 5:13 am

    #1608147

  • RE: Triggers 1

    Hugo Kornelis (4/19/2013)

    kapil_kk (4/18/2013)

    oopes,

    I think I have misunderstood the way to execute the given query...

    Oohhh, I am so sorry that the comments in the code made you misunderstand the question....

    April 19, 2013 at 2:10 am

    #1608108

  • RE: Triggers 1

    oopes,

    I think I have misunderstood the way to execute the given query...

    After seeing comments First Attempts, second, third I executed one by one those insert query and forget about the...

    April 18, 2013 at 11:40 pm

    #1608080

  • RE: Sum and Count

    Dineshbabu (4/18/2013)

    I think it's more about CROSS JOIN than SUM & COUNT.. Nice One..

    Right Dinesh 😛

    April 18, 2013 at 6:42 am

    #1607702

  • RE: Sum and Count

    Danny Ocean (4/17/2013)

    kapil_kk (4/17/2013)

    Nice question... learn something new today.. 🙂

    But can anyone plz explain me about the SUM part which is returning 12, I am not clear with this section...

    April 17, 2013 at 11:39 pm

    #1607537

  • RE: Sum and Count

    Nice question... learn something new today.. 🙂

    But can anyone plz explain me about the SUM part which is returning 12, I am not clear with this section :w00t:

    April 17, 2013 at 11:20 pm

    #1607530

Viewing 15 posts - 571 through 585 (of 1,048 total)