[SQL Server] How make procedure of below requirement in sql server 2000?

---

How make procedure of below requirement in sql server 2000? Posted: 23 Jul 2013 09:13 PM PDT Hai Friends, I m currently making one web application in that i wanna display details from data base into asp page on grid view.create table onward_journey (onwrd_id int identity,request_id int foreign key refernces request(reqst_id),from_place varchar(10),to_place varchar(10),trvael_mode varchar(10),no_of_days varchar(10))insert into onward_journey ('11','chennai','chenai','car','2')i wanna display display my page on gridviewselect from_place,to_place,travel_mode, no_of_days from travel_request where request_id=IDENT_CURRENT ('request')when i made new request also its showing old once? how to that and how to show current request_id value?

You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 20 West Kinzie, Chicago IL USA 60610