Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 25-11-2009
Member
 
Join Date: Nov 2009
Posts: 68
What are the different types of Lock available in SQL?

Hi Friends,

I am learning SQL and it's near to complete. Even though the concept of "Lock" in SQL is not yet cleared for me. I am totally confused how to understand it.

What are the different types of Lock available in SQL? What is the use them?

Your help will be greatly appreciable..
Reply With Quote
  #2  
Old 25-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: What are the different types of Lock available in SQL?

Hi,

Basically there are two main types of locks in SQL which is as below:

I) Explicit locks:
user provides this type of lock. There are also three kinds of this lock i.e Table level locks and Row level locks

II) Implicit locks:
This type of lock used by SQL system itself while operations like DML is running.
Reply With Quote
  #3  
Old 25-11-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: What are the different types of Lock available in SQL?

Hi All,

According to my SQL knowledge,three types of Lock available in SQL:

A. Exclusive lock:This type of lock is used during Update, Delete OR Insert operations.

B. Shared lock: This type of lock is used when you don't want enable to modify OR change the data.

C. Update lock: This type of lock is used during modification OR updation.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
  #4  
Old 25-11-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: What are the different types of Lock available in SQL?

Hi,

When we want to modify the particular object we can use exclusive lock for this. When we want to reserves object for reading only,then we an use shared lock. From this we can avoid modification of the object. We can apply this lock on one or more objects.
We can't apply this lock on the object when this object already has another lock.We can apply promotable locks on the object which already has shared lock.

I hope this will solve your confusion regarding Lock in SQL...
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What are the different types of Lock available in SQL?"
Thread Thread Starter Forum Replies Last Post
HP Pavilion dv4 not getting charged only Scroll/Num Lock and Caps Lock LED's blinking Pillars Portable Devices 5 31-01-2012 10:06 PM
Types of Folders lock option for Nokia N8 in computer ZewrI Portable Devices 5 10-04-2011 05:46 AM
Issue with Dinovo Mini backslash, caps lock and num lock keys Jarini Hardware Peripherals 7 02-11-2010 02:27 AM
Different types Types CCFL's Zipp Overclocking & Computer Modification 3 29-10-2009 09:11 AM
Set warning sound for Caps lock,Num lock in Windows 7 rajmalhotra Operating Systems 3 13-05-2009 02:49 PM


All times are GMT +5.5. The time now is 04:07 AM.