jana
asked on
Display the actual row the record is saved in SQL 2000
I guess this is a two part question:
1. I would to display the actual row the records are stored in the table
2. Is there a way I can use Select to display a record by just calling the actual row number the record is saved in?
1. I would to display the actual row the records are stored in the table
2. Is there a way I can use Select to display a record by just calling the actual row number the record is saved in?
ASKER
Ok.
I notice that in SQL when creating a table, there is no "row number" column included, which I understand it would be useless if included.
Ok, to further explain my question: if I create a Table with 3 columns: PatienID, PatienName and PatiendDiagnostics, I would have a SQL table structure of 3 columns. Finally we populate, import or data entry to this table 99,999 patients.
What I would like to know if SQL does have a row number or record number value stored as it saves data. And I would like to know if we can display that row number within a Select statement next to each line it displays.
I notice that in SQL when creating a table, there is no "row number" column included, which I understand it would be useless if included.
Ok, to further explain my question: if I create a Table with 3 columns: PatienID, PatienName and PatiendDiagnostics, I would have a SQL table structure of 3 columns. Finally we populate, import or data entry to this table 99,999 patients.
What I would like to know if SQL does have a row number or record number value stored as it saves data. And I would like to know if we can display that row number within a Select statement next to each line it displays.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I just read your last post after I sent mine. It sounds like you are looking for a primary key identity column. You may want to insert a new row with datatype int and set the identity property to true
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Understood, SQL does not store this value. With methods above in changing one of the columns types or storing sequential values, I can't use it since the table I want to display row-number is already being use for quite sometime; no re-restructure can be done.
Let me put the question this way:
Is there a way that after an INSERT I can recall that record location within the table without querying any of its columns? Some sort of SQL internal function that can display its location?
Let me put the question this way:
Is there a way that after an INSERT I can recall that record location within the table without querying any of its columns? Some sort of SQL internal function that can display its location?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am not to sure to understand what you are asking for?