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?
 
Back
Top