what is Isolation Level in sql server?

Question

anyone can help me to understand that what is Isolation Level in sql server?

and what it does and why, where and when it is required ?

please discuss this issue with sample code so for better visualization. thanks

Tom Mohan · Answer

Go through the below url http://gavindraper.com/2012/02/18/sql-server-isolation-levels-by-example/ http://blogs.interfacett.com/understanding-isolation-levels-sql-server-2008-r2-2012-examples http://www.besttechtools.com/articles/article/sql-server-isolation-levels-by-example if its useful mark it as accepted answer.