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 TouchToneTommy 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: *

  • Users: LLudden
  • Content: Threads
  • Order by date
  1. LLudden

    Problem with SQL 7.0 adding Trigger

    I am doing some work at a new customer who is running SQL 7 (unsure of Service pack #). I need to add an update trigger to one of the tables which contains about 70K records. There are currently no triggers defined on that (or any) tables in the database. When I enter the T-SQL for the...
  2. LLudden

    SQL Trigger Question

    I have a table of city names that are referenced in another table by the primary key: Table CityList, CityCode as int, City as nvarchar(25) Other tables that use the CityCode to reference the city name, so to get an address for a customer record, I have to query the customer table for the city...
  3. LLudden

    Changing a Table via T-SQL

    I have a software package I am doing a major update to. The original was written as an Access 2000 front end, and I am changing it that to VB6. The backend data is in SQL server 7.0 What I want to do is write T-SQL to transfer all of the existing data to a new database in SQL, and then...
  4. LLudden

    Recursive Database Design Question

    The goal of the database is to be able to choose a manufactured item, and list all the components needed to make it. Some of the components themselves are manufactured from lesser components. There can be many sub components in any given piece. Using an automobile for an example: Car...

Part and Inventory Search

Back
Top