Hello

I have a stored procedure that will insert data to table like this:

CREATE PROCEDURE dataAdd

            (

             @1stName text,

             @lastName text

            )

 AS

            INSERT INTO namesTable

                        (1stName,lastName)

                        VALUES

                        (@1stName, @lastName)

GO

I want to be able to retrieve the names ordered by listing time.

I want to use timestamp and I never used it before.

How can I do this?

Thank you

instead of using timestamp column take another column with datatype datetime and set its default value as "getdate()". using timesetamp  column is difficult to compare as it will store in binary format..

The term timestamp has been deprecated.

To use this feature, declare a column in your table with type rowversion.  Whenever the row is modified, the value of that column will be changed.  You can use such a column for concurrency control.  You can also use it in sorts or range checks.

However, for a pure date-oriented function as you describe, a datetime field is probably a better idea.

Add a DateCreated field that has a datetime data type.  Then when you insert the record, use GETDATE() to add the current date:

INSERT INTO namesTable

                        (1stName,lastName, datecreated)

                        VALUES

                        (@1stName, @lastName, GETDATE())

Then in your select, order by datecreated

select * from namesTable order by datecreated

If you want to track insert dates, you could also do this:

create table namesTable (
    Id int identity primary key,
    FirstName varchar(128),
    LastName varchar(128),
    InsertDate datetime default (getutcdate())
)

The difference between that and rowversion is that rowversion also tracks when you make changes to any column in the row.