----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: _SQL_Vinod_ Message 3 in Discussion Well, surely one of the ways has been discussed by Srini in the previous post. There is yet another way to do this is using the NOLOCK hint. Select * from <table> WITH (NOLOCK) these are the two methods that give you the desired results. But again as said in the previous post ... You would compromise on reading uncommitted data and I presume this is some business requirement ... But not justified for sure in the post ... And under both the conditions you will not get the last commited data ... But will get the last updated data on the row ... HTH, Vinod Kumar MVP - SQL Server ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
