SQL Stored Procedure imported data to wrong field

  • Thread starter Thread starter JMurray51
  • Start date Start date
J

JMurray51

I'm running MS SQL 6.5 as backend to Access 2002 program.
To enlarge a field in my SQL table, I added a field with
the same name plus "BIG", transferred the data, and
renamed the fields (old file became "filenameOLD", new
became "filename"). After refreshing my tables it works.
However, a stored procedure that appends data from another
table insists on putting the data in the "filenameOLD"
field rather than the "filename" field. Are stored
procedures in MS SQL focused on the order of the columns
rather than the name of the columns?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Column Name Sql-Error :Executing a stored procedure 1
how can i convert stored procedures in sql to stored queries in ac 1
Append to SQL Server 3
Access 2010 append query to SQL is very slow 0
Importing Text Files Into Access 1
Append Query via code: Data getting lost 2
"Data Has Been Changed" error with MSSQL 2005 backend using left j 1
Append query in SQL Server, PK error 1

Back
Top