Viewing 15 posts - 31 through 45 (of 46 total)
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....
August 20, 2003 at 2:57 pm
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...
August 20, 2003 at 11:18 am
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...
July 30, 2003 at 7:03 am
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...
July 29, 2003 at 11:08 pm
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...
July 29, 2003 at 7:07 pm
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. ...
July 29, 2003 at 11:59 am
Thanks guys....exactly what I was looking for. Man, this is a great place to learn from.
July 28, 2003 at 2:56 pm
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...
July 24, 2003 at 8:42 pm
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...
July 22, 2003 at 5:45 pm
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...
July 22, 2003 at 1:45 pm
Thanks all for your suggestions. Just to re-iterate, my way DOES work and sorts them in ASC order.
July 16, 2003 at 6:14 am
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...
July 12, 2003 at 1:33 am
I was referring to a "TinyInt" as a "byte".
May 28, 2003 at 6:48 pm
Viewing 15 posts - 31 through 45 (of 46 total)