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!

Search results for query: *

  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...

Part and Inventory Search

Back
Top