How to get the currently inserted row identity through query in sqlserver ?

hi akila
if your using SQL Server 2005, let's use @@identity.
------------------------------------------------------
USE tour;
GO
--Display the value of tour_name in the last row in the table.
SELECT MAX(tour_name) FROM tourtbl;
GO
INSERT INTO tourtbl (tour_name,min_people,max_people,unit_price)
VALUES ('UK','5','5','25000');
GO
SELECT @@IDENTITY AS 'Identity';
GO
--Display the value of tour_name of the newly inserted row.
SELECT MAX(tour_name) FROM tourtbl;
GO
----------------------------------------------------------------------------