Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 locking

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-20 : 09:12:42
deepak writes "how to lock the record while using a query
"select id,name from students"
i want to know various locks in sqlserver and and each of its use in insert ,update,delete and select etc. i am using it from visual basic 6.0

pls give reply fast"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-20 : 09:21:34
Read about locking, hints in SQL Server help file
Also read http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2006-03-20 : 09:26:57
It sounds like you might also want to read up on transactions...

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -