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 John Tel 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 benhsmith

  1. benhsmith

    Forcing a query to table scan, ignoring the useless index

    I need to force my query to ignore a useless index and perform a table scan. I think I need to use the 'with' option but can't work out the syntax.
  2. benhsmith

    Altering tables

    I have a large table (23 Million Records). A lot of the information contained within is extaneous. I want to cut some columns from the table. Can I a) truncate the columns b) drop the column c) otherwise get rid of these useless columns
  3. benhsmith

    Column Header and Results Formatting

    I am using SQL 6.5 and require to have the results of my query to appear without column headers and as Tab Delimited. i realise that I can do this through the 'Query Options' in the menu bar but I need to set this using an SQL statement in the query itself (Similarly to 'set rowcount' or 'set...
See more

Part and Inventory Search

Back
Top