Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mfranck

  1. mfranck

    How to spy all actions done to my db

    Hi there I would need to spy all actions (specially insert/ update statements) that have been done against my db. They are carried out by a third party software and I'm trying to figure out what exactly it is doing in the db. I hear using querry analizer is a way, but I can't figure out how...
  2. mfranck

    Distinct applies to all fields instead of one

    Hmm, I see now why this question might be unprecise. What I was looking for was apparently a simple select titel, typ from books group by titel This works great with MySQL. Unfortunately this statement has to work on MSSQL which returns an error that I nee to use typ in the group by because...
  3. mfranck

    Distinct applies to all fields instead of one

    When I write a statement like select distinct titel, type from books And I have two entries like titel type Nice book IT-book Nice book non IT book I'll get both entries. How can I write a querry that applies the distinct to the title column only? I tried...
See more

Part and Inventory Search

Back
Top