Forum Replies Created

Viewing 15 posts - 21,061 through 21,075 (of 26,484 total)

  • RE: indian authors for sql server book

    anu1krishna (5/11/2009)


    this is not the ans of my question please dont ask question if u dont wann to give ans.//

    In answer to your question, none that I know of. ...

  • RE: Execute a stored procedure inside a user defined function

    herbey zepeda (9/30/2008)


    I'm not sure about this, you can't generate a newid() inside a function. It's generating an error when trying to do so, yet in a sproc you can,...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (5/11/2009)


    Steve Jones - Editor (5/11/2009)


    Andy Warren actually big on a few props from the auction. I think he got a flute or some minor prop from one of...

  • RE: Are the posted questions getting worse?

    Anybody watch the History Channel (US) this weekend? I caught a story about Paramount auctioning off a lot of Star Trek props. The model for the Enterprise D...

  • RE: Concurrency Question

    Paul White (5/11/2009)


    Lynn,

    Ok - no worries. It seems I did misunderstand you!

    Do please run the script I posted when Real World commitments allow - I remember being quite surprised...

  • RE: Concurrency Question

    Paul White (5/10/2009)


    Lynn,

    Lynn Pettis (5/10/2009)


    I think that is something I'd want to verify before stating.

    I am wounded - you seem to suggest that I did not verify it...!

    Lynn Pettis (5/10/2009)


    You...

  • RE: Concurrency Question

    Paul White (5/10/2009)


    Lynn Pettis (5/10/2009)


    All I wanted to make sure was that it isn't the BEGIN TRANSACTION (explicit or implicit) that creates any locks.

    Sure. BEGIN TRANSACTION doesn't even get...

  • RE: Concurrency Question

    Paul,

    All I wanted to make sure was that it isn't the BEGIN TRANSACTION (explicit or implicit) that creates any locks. This part of a transaction does not know what...

  • RE: Concurrency Question

    Jamie,

    Thank you for taking the time to read my blog. I can tell you, from my own point of view, that the more you tell me up front the...

  • RE: Problem segregating third occurence from a column

    saurabh.dwivedy (5/8/2009)


    DECLARE @addr VARCHAR(1000), @delim CHAR(1), @x INT

    SET @delim = '*'

    SET @addr = '5605 PRINCETON AVE STE B* COLUMBUS* GEORGIA*31904*(01/11/06 -...

  • RE: Original Theatrical Release of Star Wars

    Dave (5/8/2009)


    I saw it with Linda, a girl I was dating. When we got to the box office, the ticket seller says, "I only have two together in the...

  • RE: Concurrency Question

    Jamie Julius (5/8/2009)


    Paul White (5/8/2009)


    Jamie Julius (5/7/2009)


    It seems to me that the proposed SQL would be considered an implicit transaction. It would be run under the default isolation mode of...

  • RE: Invalid use of a side-effecting operator 'INSERT EXEC' within a function:

    Does this mean creating a view using the OPENROWSET function didn't work? It is how I got around not being able to use NEWID() in a function, I put...

  • RE: Concurrency Question

    Stepping back a moment, dealing with difficult users - the flip side (yes, my post dealing with us (me)).

    The best way to "defeat" us is with information. The more...

  • RE: Concurrency Question

    Bob Hovious (5/8/2009)


    For clarity, note that Bob's example also fails if READ_COMMITTED_SNAPSHOT is on.

    Are you real sure about that Paul?

    Did you try it? ...

Viewing 15 posts - 21,061 through 21,075 (of 26,484 total)