Whether Transactions(Commit, Rollback) will lock any data or table?

I just want to ask whether using Transactions(Commit, Rollback) will lock any data/table? Please provide me link开发者_StackOverflow中文版s about this.

---

I think this may help - http://msdn.microsoft.com/en-us/library/ms173763.aspx

It depends on your transaction isolation level for each of the clients. There are several settings, such as READ COMMITTED, READ UNCOMMITTED, and REPEATABLE READ