Wow, that's more than a little bit scary. If you are working on a stock
trading app and you don't know about locking I hope my stocks aren't
depending on that app. In any case there is nothing special about a
stock app than any other really as the same principles apply. I would
recommend the Inside SQL Server 2005 series of books but this one in
particular has a section on locks and deadlocks.

http://www.amazon.com/Inside-Microso.../dp/0735621969

There are also lots of good articles on the web available with a simple
Google search.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Smith" <naissani (AT) hotmail (DOT) co> wrote