Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - just save N record to database ...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

just save N record to database ...
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
miladanimator View Drop Down
Groupie
Groupie
Avatar

Joined: 24 July 2005
Location: United States
Status: Offline
Points: 156 		Post Options Post Options   Thanks (0) Thanks(0)   Quote miladanimator Quote  Post ReplyReply Direct Link To This Post Topic: just save N record to database ...
    Posted: 12 July 2006 at 5:45am
hi all!

I write a shout box in asp + ms sql server database ...

and now I need a code that help me too :

I want to save just last 25 records in the database and other recordes delete automatically ...

I mean : when a user add a new sout in box , this shout add too the database and an old shout delete from database ...
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 14 July 2006 at 4:37pm
Assuming you are using SQL2k5 you can use a Derived Table with the new Row_Nubmer Function. I am sure there are other ways but this one is simple. You may have to tweak it to make it work fo you


With deleteOver AS
(Select ID, Row_Number() OVER (Order by ID DESC) as RowNumber from myTable)
Delete from deleteOver where RowNumber > 25
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.