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

    How to handle INSERT INTO with varchar Primary Key(PK) column

    On the last script I get this result: MaxString MaxInt 0000003116 3116
  2. ouroboros12321

    How to handle INSERT INTO with varchar Primary Key(PK) column

    Ah, of course it's not going to pull anything from an empty table. Result for the first script: 0000003116 Result for the second script: 0
  3. ouroboros12321

    How to handle INSERT INTO with varchar Primary Key(PK) column

    gmastros, thanks for taking the time to respond. I completely understand what you mean about inserting a number into a varchar column. This was built a long time ago and I cannot modify it. As for your proposed solution, I made the changes you recommended and still got the same error: ---------...
  4. ouroboros12321

    How to handle INSERT INTO with varchar Primary Key(PK) column

    Simian, I'm not sure what you mean by reproduce the PK value. If you are talking about identifying the last PK used then starting from there, I'm not sure how to do that. Regardless, I visually looked to see what was the last PK number used, tried to write that value into the field, and still...
  5. ouroboros12321

    How to handle INSERT INTO with varchar Primary Key(PK) column

    Hopper44, thanks for the reply. Maybe my post wasn't clear, but I don't pull any unique values from the text file; better yet, any information that I pull from the text file is not intended to go into a primary key field. Ultimately, I want to add the data from the text file to a table which...
  6. ouroboros12321

    How to handle INSERT INTO with varchar Primary Key(PK) column

    Hello, I've recently began learning SQL with SQL Server and it's been a blast so far. Right now, I am having a problem figuring out how to insert certain data into a destination table (not created by me, cannot alter it) that has a PK field which is a VARCHAR type and it doesn't appear to be an...

Part and Inventory Search

Back
Top