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.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-06-18 : 07:48:22
|
JIgnesh Pandya writes "Hello Sir My name is jignesh. I am developing a siftware where in my backhand is sql server is 2000 and front end is vb 6.0.In my database i have a table customer.I have also created a of customer table name custdisp.Through VB 6.0 i am Inserting records in Customer table throughConnection objecti.eCon.BeginTrans con.execute "Insert Into Customer"con.committransIn this case theb customer table will be lock but all the other views related to custometr table also get lock.I dont want the custdisp view to lock even if I update the table through begin trans and commit trans." |
|
Nazim
A custom title
1408 Posts |
Posted - 2003-06-18 : 09:06:34
|
Write a stored procedure and call it .not only it will solve your locking issues also there r lot of other advantages using sp like reducing n/w trafic, using cache plan etc.-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo EmersonEdited by - nazim on 06/18/2003 09:07:45 |
|
|
|
|
|