Post reply

set commands

  • July 9, 2009 at 3:43 pm

    #103783

    Hi Guys,

    We normally set our enviroment while working in Query Analyzer inside the Management Studio. Right?

    For we set our environemt saying,

    SET NO COUNT ON

    SET ANSI_NULLS ON

    SET IMPLICIT_TRANSACTIONS ON and so on....

    Like Oracle, we use a command SET <> which displays the current settings in the sqlplus or sqlplusw windows. Do we have any similar kind of command through which we can display all the settings made to my current Query Window????????

  • July 9, 2009 at 5:38 pm

    #1022790

    Duplicate post. Please don't post replies here. Instead, see the following URL...

    http://www.sqlservercentral.com/Forums/Topic750661-146-1.aspx

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 9, 2009 at 10:03 pm

    #1022843

    Sorry My Bad!!!

    I should have posted this in Development Category.

Viewing 3 posts - 1 through 2 (of 2 total)

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