Forum Replies Created

Viewing 15 posts - 31 through 45 (of 46 total)

  • RE: Question Regarding XACT_ABORT ON

    GuardData, you are correct. As a matter of fact, I do return custom codes to my application because as you stated they won't be handled by the XACT_ABORT statement....

  • RE: Question Regarding XACT_ABORT ON

    I wanted a way so that I didn't have to check for errors after each action statement. By using XACT_ABORT, I catch my errors in my .NET web application...

  • RE: Doing Short Circuiting in WHERE clause

    alzdba, DavidBurrows

    When I said I would use Dynamic SQL, I was thinking of the sp_executeSQL way (as per Scott's suggestion), and NOT doing it from the client side. As...

  • RE: Doing Short Circuiting in WHERE clause

    Here it is. This is one of the examples where I was planning on reworking the WHERE clause as per this thread. The function that I was referring...

  • RE: Doing Short Circuiting in WHERE clause

    Actually, I did think of implementing 'jpipes' method before I posted. But when you give users 4 to 8 different ways to tailer their search, like Scott says, the...

  • RE: Doing Short Circuiting in WHERE clause

    alzdba. I'm "only" doing it for search forms. In my search forms, I let the user enter whatever details they want....like say BusinessName, ContactType LocationType, Location, etc. ...

  • RE: Doing Short Circuiting in WHERE clause

    Thanks guys....exactly what I was looking for. Man, this is a great place to learn from.

  • RE: Question Regarding XACT_ABORT ON

    Thanks Chip. I see that I forgot to wrap it around a transaction. For some reason I assumed the SP was itself the transaction wrapper when XACT_ABORT ON...

  • RE: Silly Question

    Yup.....almost as good as Einstein's MC^2.

  • RE: Silly Question

    brendthess,

    Damn, that is a SLICK but ELEGANT way of doing it. Thanks! I must admit, at first glance, I had to strain my brain "a little" to figure what you...

  • RE: Silly Question

    Sorry, I forgot to mention that IsActive is a bit field and allows for NO nulls.

    MarkusB, your way is not the same thing because yours returns "actives" OR...

  • RE: Sorting

    Thanks all for your suggestions. Just to re-iterate, my way DOES work and sorts them in ASC order.

  • RE: Sorting

    I just figured out how to go about it. Something like this seems to work:

    SELECT ID, Name, SortOrder

    FROM NameType

    ORDER BY -SortOrder DESC

    (Note the "-" in the order by clause.)

    --Lenard

    Edited...

  • RE: Sorting

    That is what I thought. Darn! 🙂

    --Lenard

  • RE: Indexing Tables with Byte type fields

    I was referring to a "TinyInt" as a "byte".

Viewing 15 posts - 31 through 45 (of 46 total)