Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 date question

Author  Topic 

moramoga
Starting Member

34 Posts

Posted - 2008-01-04 : 08:51:13
hi guys,

Simple question, I have a a table that has a datetime column, I need a store procedure that returns me the last 5 insertions, type of a recently added, thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-04 : 08:53:59
SELECT TOP 5 * from TABLE ORDER BY datefield desc
Go to Top of Page
   

- Advertisement -