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 Shaun E 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. cclabaugh

    Excel Parameter: How to show in spreadsheet

    I have a worksheet that runs a db query based upon two parameters. Once the data has been retrieved from the database, how do I show on my spreadsheet the parameters that were sent to get the data?
  2. cclabaugh

    Trigger for creation Date, Time & last update Date , Time

    Found the problem: For SQL 2000 use the following example: CREATE TRIGGER trgUpdateLastModified ON [dbo].[tblVehicles] FOR UPDATE AS UPDATE tblVehicles SET LastModified = GetDate() From tblVehicles, inserted WHERE tblVehicles.VehicleID = Inserted.VehicleID
  3. cclabaugh

    Trigger for creation Date, Time & last update Date , Time

    I have done this method, however, it updates every row in my table. How can I write the trigger so that it only updates the LastModified column for the row that was modified, regardless of what column was changed?
  4. cclabaugh

    Dropping Extra Tables

    Thank you, that worked great.
  5. cclabaugh

    Dropping Extra Tables

    I'm looking for a way to query an existing table that has other valid table names that we are using in it and then compare those tables to the list of tables that actually exist in the db. If there are extras, I want to delete them. I tried to query my table and then delete all extra tables that...

Part and Inventory Search

Back
Top