Forum Replies Created

Viewing 7 posts - 1 through 8 (of 8 total)

  • RE: DML Triggers

    The question is: "how many types of DML triggers in present?" So the answer should be : 3 types of DML triggers: CLR Triggers, AFTER Triggers,INSTEAD OF Triggers.

    Cheers,

    Sur...

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

    December 12, 2007 at 10:51 pm

    #759689

  • RE: DML Triggers

    There are 3 types of DML triggers: CLR Triggers, AFTER Triggers,INSTEAD OF Triggers. Answer given is wrong in the post.

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

    December 12, 2007 at 4:11 am

    #759337

  • RE: Analyzing and Optimizing T-SQL Query Performance Part 1

    Where is the article?

    I could not able to see it. 🙁

    I think the it is missing.

    Regards,

    Sur

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

    December 7, 2007 at 3:15 am

    #757994

  • RE: 10/23/07

    Please give me my points, I gave the correct answer 🙂 but there it is showing as wrong 🙁

    Such kind of errors can be avoided if the Answer given by...

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

    October 23, 2007 at 11:27 pm

    #744759

  • RE: 10/23/07

    I think the answer is RANK() but the correct answer mentioned is ROW_NUMBER.

    How it could be?

    Can anyone explain it?

    Look below:

    Correct answer:

    ROW_NUMBER

    Explanation:

    RANK() is the correct function as it will...

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

    October 23, 2007 at 4:12 am

    #744404

  • RE: Native XML Web Services

    Hi,

    I believe this will help you in this regard....

    http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/

    http://www.developer.com/db/article.php/3547866

    Cheers,

    Sur...

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

    October 15, 2007 at 11:40 pm

    #742221

  • RE: Convert SQL 2000 DTS Jobs to SSIS in SQL 2005

    I think this will help you....

    http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

    See the "The Upgrade Mechanism" section in this article

    Cheers,

    Sur...

    "I have always wanted the best for myself, so that I can...

    -------------------------------------------
    Cheers,
    Sur...
    '[font="Tahoma"]The bend in the road is not the end of the road Unless u refuse to take the turn[/font]"

    September 11, 2007 at 11:54 pm

    #733006

Viewing 7 posts - 1 through 8 (of 8 total)