how to delete last inserted row in sql server

[sumit anand]

how to delete last inserted row in sql server

[Rabbit]

You would need an auto increment field or a date field that defaults to when the row is inserted.

[mukherjee]

delete top 1 from <table>.

[Rabbit]

Mukherjee, your code will not work.

[twinnyfo]

sumit anand,

You would need a way to know which record was the last inserted. Rabbit's suggestion of an auto-increment field will tell you the most recent, based on the record with the largest value.

@mukherjee, your method willonly delete the first record the query finds, which could be just about any record, depending upon how the query is written.