Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 7,483 total)

  • RE: Central Respository

    Are the questions getting too easy?

    Nice question, but the answer is a bit too obvious, I think.

    Tom

    September 5, 2014 at 5:51 am

    #1743481

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/4/2014)

    So ANSI Joe is still at it? It has been a very long time since I have been to the forums.

    Do we have any new ANSI Joe...

    Tom

    September 4, 2014 at 6:40 pm

    #1743370

  • RE: Question regarding the difference between two different ways to populate a new table in TSQL

    Jeff Moden (9/3/2014)

    Again, Gail will already know the reason for the performance boost in the second While Loop. I'm probably not using the right terminology but the simple explanation...

    Tom

    September 4, 2014 at 6:24 pm

    #1743369

  • RE: Today's Random Word!

    Ed Wagner (9/4/2014)

    djj (9/4/2014)

    Ed Wagner (9/4/2014)

    Revenant (9/4/2014)

    SQLRNNR (9/4/2014)

    silver

    spoon

    Feed

    Qats

    Granola

    Museli

    Tom

    September 4, 2014 at 6:15 pm

    #1743368

  • RE: What will this query return?

    Good analysis, Hugo, but personally I regard terminating "begin" as an abomination - after all, it is not a statement but a bracket indicating that a compound statement begins here....

    Tom

    September 4, 2014 at 6:10 pm

    #1743367

  • RE: What will this query return?

    Nice clear question.

    It's also a neat demonstration of how idiotic it was to use rge word "with" to introduce a CTE definition. There were other possibilities, some of them...

    Tom

    September 4, 2014 at 11:13 am

    #1743284

  • RE: Trigger or Not Trigger

    ScottPletcher (9/3/2014)

    LutzM (9/3/2014)

    ScottPletcher (9/3/2014)

    ...

    There are 3rd party solutions that do that, but they are rather expensive. At least one we investigated uses its own "black box" to hold the...

    Tom

    September 3, 2014 at 6:08 pm

    #1743049

  • RE: Trigger or Not Trigger

    ScottPletcher (9/3/2014)

    Triggers can capture the originating user as well if you provide that info to the trigger. This can be passed in several ways, including CONTEXT_INFO, APP_NAME or even...

    Tom

    September 3, 2014 at 5:47 pm

    #1743047

  • RE: Today's Random Word!

    Ed Wagner (9/3/2014)

    SQLRNNR (9/3/2014)

    djj (9/3/2014)

    SQLRNNR (9/3/2014)

    slag

    heap

    sludge

    Flood

    Gates

    Tom

    September 3, 2014 at 5:32 pm

    #1743046

  • RE: Are the posted questions getting worse?

    Luis Cazares (9/3/2014)

    Koen Verbeeck (9/3/2014)

    Bah. I couldn't resist it.

    Someone call the Relational Protection Agency, we have an offender...oh, wait. 😀

    Actually I reckon the NPA people should have been Joe and...

    Tom

    September 3, 2014 at 5:24 pm

    #1743045

  • RE: Using COALESCE and also trying to multiply and divide

    CELKO (9/3/2014)

    My guess is that you should had a talbe like this:

    CREATE TABLE Rents

    (property_id CHAR(15)NOT NULL,

    rental_month CHAR(10) NOT NULL

    CHECK (rental_month LIKE '[12],[0-9][0-9][0-9]-[01][0-9]-00'),

    That's downright appalling....

    Tom

    September 3, 2014 at 4:36 pm

    #1743041

  • RE: Using COALESCE and also trying to multiply and divide

    CELKO (9/3/2014)

    Do you have you copy of the ANSI/ISO Standards? Read them. The only display format allowed is ISO-8601, 'yyyy-mm-dd' and not your punctuation free version. Sorry.

    Seems...

    Tom

    September 3, 2014 at 4:10 pm

    #1743033

  • RE: TVP

    palotaiarpad (9/3/2014)

    I thought it'd fail at:

    CREATE PROCEDURE [TEST].[PopulateAddress] (@Address AS TVP.Address READONLY)

    BOL has no reference to this 'AS':

    [ { @parameter [ type_schema_name. ] data_type }

    ...

    Tom

    September 3, 2014 at 11:22 am

    #1742933

  • RE: Are the posted questions getting worse?

    Luis Cazares (9/3/2014)

    xsevensinzx (9/3/2014)

    Koen Verbeeck (9/3/2014)

    xsevensinzx (9/3/2014)

    I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to...

    Tom

    September 3, 2014 at 9:24 am

    #1742864

  • RE: Are the posted questions getting worse?

    Luis Cazares (9/3/2014)

    xsevensinzx (9/3/2014)

    Koen Verbeeck (9/3/2014)

    xsevensinzx (9/3/2014)

    I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to...

    Tom

    September 3, 2014 at 9:10 am

    #1742853

Viewing 15 posts - 2,251 through 2,265 (of 7,483 total)