Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to insert a record in the last position of a file?
0 views
Skip to first unread message
Mike Sánchez
May 17, 2010, 9:13:02 PM5/17/10
to
Hello. i need to store a record in the last positon on the file. This file
does not require a key field(s) because i neeed that information in the same
order as they were captured. I do an Insert Sql query, but the new record
doesn't be in the last position. i want to know how to reach de last
position to insert the record; if there as a pointer to the last position,
etc. i've been using Access, and with dao AddNew appends a record in the
last position os the file, but Insert (SQL) with SQL Server 2005 doesn´t.
Thanxs in advance.
does not require a key field(s) because i neeed that information in the same
order as they were captured. I do an Insert Sql query, but the new record
doesn't be in the last position. i want to know how to reach de last
position to insert the record; if there as a pointer to the last position,
etc. i've been using Access, and with dao AddNew appends a record in the
last position os the file, but Insert (SQL) with SQL Server 2005 doesn´t.
Thanxs in advance.
SQL Servant
Jul 20, 2010, 10:03:13 AM7/20/10
to
You could try using an ID column so that every time you insert a new row it
will be assigned the next ID number. The table will then hold records in the
order they were entered.
will be assigned the next ID number. The table will then hold records in the
order they were entered.
Regards,
SQL Servant
0 new messages