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

  1. wildsol

    Insert TableA into TableB

    Make sure that when you are inserting into table A that you are not including the autonumber field for the table in the insert statement. from what you originally posted: INSERT INTO TableA( a, b, c, d, e ) SELECT A, B, C, D, E FROM TableB If field x was the autonumberfield for table A, you...
  2. wildsol

    Proper case

    You have to make sure you add the user prefix when calling the function (e.g., dbo.propercase(lastname) )

Part and Inventory Search

Back
Top