as per Mr. White Ans i.e. OK. If the two things happened at EXACTLY the same moment (the database was set up so that the INSERT didn't block the SELECT...

simply i want to see weather it will show the old record or new inserted record ......(i am talking about the exceptional case when inset the data and select statement...

but suppose the Exceptional case when both insert and select(used in differnt systems and both usres using the same database) statement occured at the same time??then in this case what...