Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 8,416 total)

  • RE: Deleted and Inserted On A Trigger

    Dev @ +91 973 913 6683 (11/8/2011)


    Thanks Gail but the part that I didn't find was parser.

    I'm not sure exactly what you're asking here, but this is from http://msdn.microsoft.com/en-us/library/ms190623.aspx:

    Processing a...

  • RE: Help searching a string within a set number of words apart

    lewisdow123 (11/8/2011)


    I'm leading down the regex path first using the link provided and http://www.sqlteam.com/article/regular-expressions-in-t-sql

    Yes that's the CLR route I would try too. The T-SQL code I posted was more...

  • RE: RBAR

    steveb. (11/8/2011)


    Theres no point, SQL server has an in-built one with spt_values up to 2047 rows

    Oh I wouldn't say that - several of the previous solutions...

  • RE: Deleted and Inserted On A Trigger

    GilaMonster (11/8/2011)


    You could argue validly that compile is parse + bind (algebriser) + optimise, or that compile = optimise. I don't think I've ever seen any article/help file that uses...

  • RE: Deleted and Inserted On A Trigger

    Dev @ +91 973 913 6683 (11/8/2011)


    Gail, I will accept your comments if I find any supporting documents on MSDN. I don't find any (I googled it as well). Can...

  • RE: SQL conundrum

    PaulB-TheOneAndOnly (11/8/2011)


    Not in the sense of over-booking partial flight legs like this system does

    Fair enough. Booking part of a flight is an intriguing idea though - parachutes supplied?

  • RE: SQL conundrum

    PaulB-TheOneAndOnly (11/8/2011)


    Never seen a system designed to overbook resources on purpose before

    Don't airlines do this routinely on the basis that some people will cancel at the last minute or simply...

  • RE: Intersect

    Hugo Kornelis (11/8/2011)


    I only have SQL Server 2008 R2 with SP1 installed, so I can't reproduce the bug. Maybe someone who does have an older version with the bug still...

  • RE: Help searching a string within a set number of words apart

    lewisdow123 (11/8/2011)


    With out sounding like an SOB that's the problem I am having, finding all those that have words within a set distance from each other. The pre-filter is...

  • RE: RBAR

    Never mind - silly idea deleted.

  • RE: Help searching a string within a set number of words apart

    I think I would look to write a full-text query to get results that might match (i.e. the text has all the words specified, perhaps using NEAR, perhaps not) and...

  • RE: Intersect

    vk-kirov (11/7/2011)


    Very interesting question, but 1) version-specific; 2) with wrong explanation.

    Exactly. I was at a loss which answer to choose because they all seemed wrong. Turns out I...

  • RE: Filtered index with IS NULL predicate

    GilaMonster (11/8/2011)


    Time to reopen the item I think.

    It'll be interesting to see if you can - I know Aaron has had trouble re-opening things recently.

    Anyway, yes this needs clarifying -...

  • RE: execute stored procedure with order by

    GilaMonster (11/8/2011)


    SQL Kiwi (11/7/2011)


    daveriya (11/7/2011)


    i am converting function into sp,can i execute like this exec proc proc_name 'parm1' 'parm2' order by column.

    Given that the best solution is to insert into...

  • RE: Deleted and Inserted On A Trigger

    Gil_Adi (11/8/2011)


    What I had In Mind Is to Create Temporary Tables for deleted and inserted and than create an Index on them for the fields Key and sex ,then...

Viewing 15 posts - 1,546 through 1,560 (of 8,416 total)